DROP SCHEMA if exists chqin CASCADE;
CREATE SCHEMA chqin;
SET search_path TO chqin,public;
DROP TABLE if exists rqg_table1 cascade;
CREATE TABLE rqg_table1 (
c0 int,
c1 int,
c2 text,
c3 text,
c4 date,
c5 date,
c6 timestamp,
c7 timestamp,
c8 numeric,
c9 numeric)   ;
CREATE INDEX idx_rqg_table1_c1 ON rqg_table1(c1);
CREATE INDEX idx_rqg_table1_c3 ON rqg_table1(c3);
CREATE INDEX idx_rqg_table1_c5 ON rqg_table1(c5);
CREATE INDEX idx_rqg_table1_c7 ON rqg_table1(c7);
CREATE INDEX idx_rqg_table1_c9 ON rqg_table1(c9);
INSERT INTO rqg_table1 VALUES  (1, 4, 'bar', 'foo', '2021-07-03 03:17:02', '2031-12-18', '1981-05-16 10:44:54.026316', NULL, -0.123456789123457, 1.23456789123457e+39) ,  (1, 7, 'bar', 'foo', '1991-06-17 07:08:41', '2001-06-19 22:42:48', '2032-01-15 19:24:15', '2014-05-25 01:22:26', 2.913547483932e+18, 8.43902587890625e+80) ,  (5, -1813577728, 'bar', 'iolblm', '1999-09-09 07:53:14', '2029-07-19 03:30:43', '2024-12-19 22:06:16', '2002-04-01', 0.123456789123457, -1.23456789123457e+30) ,  (9, 7, 'foo', 'olblmqkjqqlrtuwykrawvrwdcizbghxbfuxjvlpoxntubbqcfebqdwnzfxs', '2030-07-18', '2035-07-04 15:52:25', NULL, '2019-08-08 10:54:58.032066', 1.23456789123457e+44, -0.123456789123457) ,  (4, 3, 'lblmqkjqqlrtuwykrawvrwdcizbghxbfuxjvlpoxntubbqcfebqdwnzfxsbztab', 'blmqkjqq', '2035-04-06 11:58:34', '2014-01-07 07:39:14', '2030-08-13 06:58:43.040732', NULL, 7.43408203125e+80, -1.23456789123457e+44) ,  (6, 9, 'lmqkjqq', 'bar', '2012-04-24 00:12:33', '1985-02-12', '2031-06-25 22:40:28.021350', '2019-08-26 18:38:25.015078', -1186463744, -1.23456789123457e-09) ,  (2133262336, 2, 'foo', 'foo', '2029-07-28', '1977-02-09 12:33:51', '1988-02-12 19:37:38.007088', '2029-02-26 21:54:37.049148', -1.23456789123457e+44, -1.23456789123457e+25) ,  (5, 771620864, 'mq', 'qkjqql', '2027-08-28', '2020-02-25', '2023-08-06', '1992-04-20 13:15:47', 1.23456789123457e+30, 1.23456789123457e+44) ,  (-928186368, 1, 'kjqqlrtuwykrawvrwdcizbghxbfuxjvlpoxntubbqcfebqdwnzfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosg', 'jqq', '2014-11-19 01:50:52', '1972-07-19', '2004-09-05 13:52:03.016682', '2022-04-05 01:00:44.008797', 1.23456789123457e+43, 1.23456789123457e-09) ,  (-639565824, 9, 'qqlrtuwykrawvrwdcizbghxbfuxjvlpoxntubbqcfebqdwnzfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieu', 'qlrtu', '2025-03-16 21:03:33', '2032-06-14 14:09:02', '1996-02-10 09:07:06.038457', '1976-03-15 04:01:13.045749', -0.123456789123457, 1.27471923828125e+80) ,  (-2116681728, 7, 'lrtuwyk', 'rtu', '1996-10-08 16:13:59', '1988-12-14 00:47:36', '1972-07-26 12:42:38.065132', '1986-05-09 13:40:21', 1.23456789123457e+44, 0.873489379882812) ,  (-315817984, 5, 'foo', 'foo', '1971-02-01 09:38:34', '2001-08-20', '1995-10-07 17:36:34', NULL, 1.23456789123457e-09, 1.23456789123457e+43) ,  (1, 2, 'foo', 'tuwykraw', '2002-07-02 20:09:12', '2028-05-03 09:14:28', '1999-06-25', '2014-05-03 19:53:54.021989', -6.36001586550064e+124, 1.23456789123457e+30) ,  (6, -1995112448, 'foo', 'bar', '1984-04-19', '1980-07-22', '1988-01-19', '1999-05-16 20:12:16.042246', -1.23456789123457e+43, 5.2433158661661e+18) ,  (-1201995776, -1884749824, 'bar', 'uwykrawvrwdcizbghxbfuxjvlpoxntubbqcfebqdwnzfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieu', '1996-10-18 08:19:14', '1980-03-01', '2010-05-20 03:01:46.033713', '1987-10-11 11:17:47.020729', -0.123456789123457, -1.23456789123457e+44) ,  (4, 1428881408, 'foo', 'wykrawvrwdcizbghxbfuxjvlpoxntubbqcfebqdwnzfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxy', '2014-08-19', '1990-05-01 02:11:12', '2027-11-06 22:15:33.004879', '1999-12-06', 1.23456789123457e+30, -1.23456789123457e+43) ,  (1675755520, 1824849920, 'ykr', 'krawvrwd', '2004-06-18 14:38:21', '1978-08-20 16:59:47', '2011-09-26 04:41:48.033256', '2031-11-14', -1.23456789123457e+43, 1.23456789123457e+39) ,  (2, 2, 'foo', 'rawvrwdcizbghxbfuxjvlpoxntubbqcfebqdwnzfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieu', '2004-01-16 12:23:53', '2017-05-23', '2013-12-21', '1994-05-14 03:10:32.028217', 1.23456789123457e-09, -1.23456789123457e+30) ,  (-465043456, 1, 'awvrwdcizbghxbfuxjvlpoxntubbqcfebqdwnzfxsbztabymajfwyeozaurhjoddxor', 'foo', '1975-09-23 16:31:36', '2003-12-23', NULL, '1992-04-27 06:21:26', 1.23456789123457e+25, -1.23456789123457e+44) ,  (1, 0, 'bar', 'foo', '2024-02-23 07:54:01', '2034-01-16 17:23:27', '2022-06-02 15:22:28', '2017-10-18 20:57:49.049629', 0.123456789123457, -6.85302734375e+80) ,  (0, 3, 'wvrwdcizbghxbfuxjvlpo', 'bar', '2025-08-06', '2030-10-26 07:11:14', '2005-08-06 20:07:58.028377', '1979-04-25 07:47:59.038315', 1159987200, -1163460608) ,  (6, 1, 'bar', 'bar', '2019-11-26', '1984-10-05', NULL, '2015-07-08', -1.23456789123457e+43, -1.23456789123457e-09) ,  (2, 6, 'foo', 'foo', '1975-04-15', '2000-08-20 16:34:05', '1982-04-23 19:36:37.042876', '2022-09-26', -5.53182771729452e+18, 0.707992553710938) ,  (7, 1, 'bar', 'vrwdcizbghxbfuxjvlpoxntubbqcfebqdwnzfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhm', '2021-08-17', '1981-09-01 02:06:40', '2035-03-27 01:19:45', NULL, -1.23456789123457e+30, 9.075927734375e+80) ,  (7, -1820262400, 'bar', 'foo', '1983-12-01', '2004-12-15', NULL, '2014-11-09 18:35:50.027568', -1.23456789123457e+39, 0.123456789123457) ,  (-357761024, 0, 'rwdcizb', 'wdcizbghxbfuxjvlpoxntubbqcfebqdwnzfxsbztabymajfwyeozaurhjoddxorsiyt', '2003-02-18 17:30:54', '1981-12-02 02:17:25', '2024-07-25 07:17:58', '1992-07-27 17:02:45', 943980544, -1207762944) ,  (144506880, 922222592, 'foo', 'foo', '2013-01-11', '2025-09-11 20:29:04', NULL, '2034-02-21 11:48:31', -1.23456789123457e-09, -1.23456789123457e+43) ,  (1206321152, 9, 'dcizbghxb', 'foo', '1980-07-08', '2004-05-26', '2016-02-06', NULL, 0.123456789123457, 1.23456789123457e+39) ,  (7, 1, 'foo', 'bar', '2012-12-25', '1977-07-23', '2027-05-22 02:27:06', '1986-12-14 22:58:52.036586', 1.23456789123457e-09, 1.23456789123457e+44) ,  (1, 1, 'foo', 'cizbgh', '1974-04-02', '1994-01-07 01:29:54', '2024-04-17', NULL, -0.123456789123457, -1.23456789123457e+39) ,  (8, 6, 'izbghxbfuxjvlpoxntubbqcfebqdwnzfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmy', 'zbghxbfuxjvlpoxntubbqcfebqdwnzfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeu', '2003-02-17 23:05:55', '2033-05-23 14:40:54', '1986-02-09 13:03:44.034396', NULL, 1.23456789123457e+43, 3.52783203125e+79) ,  (6, -1845428224, 'bghx', 'ghxbfuxjvlpoxntubbqcfebqdwn', '2011-05-24', '1981-07-17', '2003-05-06', '2024-07-01 02:49:01.060571', -0.123456789123457, -1.23456789123457e+43) ,  (2029846528, 4, 'bar', 'foo', '2019-07-15 04:36:58', '1979-02-08 15:16:01', NULL, '2012-04-11', 1.23456789123457e-09, 1.23456789123457e+30) ,  (1, 7, 'bar', 'hxbfuxjvlpoxntubbqcfebqdwnzfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpl', '1976-11-17 13:46:02', '2031-05-27', '1985-12-05 11:09:31.032960', '1994-11-17 23:57:36.065511', 1.23456789123457e+43, -1.23456789123457e+44) ,  (-1541210112, 3, 'xbfuxjvlpoxntubbqcfebqdwnzfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosgg', 'bar', '1998-02-05 14:59:35', '2023-03-26 23:35:40', '1973-02-14 09:13:05.020829', '1986-10-27', -1.23456789123457e+44, 1.23456789123457e-09) ,  (1428226048, -1979383808, 'bar', 'b', '1993-02-27', '1981-12-12', '2007-10-09 05:23:46.013017', '2026-04-20 21:10:56.000132', 8.597412109375e+80, 1.23456789123457e+44) ,  (1, -1117192192, 'bar', 'fuxjvlpoxntubbqcfebqdwnzfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliww', '2024-10-16 00:25:47', '2005-12-14', '2032-09-03 01:28:24.061247', '1989-11-05 15:47:53.008028', 1.23456789123457e+39, 1.23456789123457e-09) ,  (981073920, 1, 'ux', 'bar', '2029-02-15 18:39:33', '1994-10-15', NULL, '1971-12-09 04:21:24.004321', -0.123456789123457, -1.23456789123457e+30) ,  (1, 7, 'foo', 'bar', '1981-09-10', '1975-05-19 23:05:31', '1976-10-23 03:05:19.049647', '1982-10-19 15:58:48', -2043543552, -1.23456789123457e+25) ,  (1, 1, 'foo', 'xjvlpoxnt', '2005-06-17', '1989-01-21 04:25:45', '2014-09-20', '1980-01-01 14:50:17.065052', 1.23456789123457e+25, -1.23456789123457e-09) ,  (0, 5, 'jvlpoxntubbqcfebqdwnzfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilao', 'vlpoxntubbqcfebqdwnzfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolev', '1980-05-26 21:28:00', '1984-07-25 13:51:38', '2003-11-03 03:20:17.007700', '1995-05-14 00:03:39.004265', 9.01763916015625e+80, -1.23456789123457e+25) ,  (8, 303300608, 'foo', 'lpox', '1973-08-18 07:41:52', '2002-08-19', NULL, '1985-06-06 05:53:24', -1.23456789123457e+39, -1.12589990684262e+17) ,  (2, 0, 'poxntu', 'bar', '2030-02-24', '1995-07-01 21:59:56', NULL, '2015-08-24', -9.1766357421875e+79, -2.4116776004569e+18) ,  (1, 780402688, 'oxntubbqcf', 'xnt', '1996-11-19 04:24:42', '2010-03-13 15:13:53', '1980-11-20', '1976-04-25 02:58:02.009621', 1.23456789123457e+30, 1.23456789123457e+39) ,  (6, 3, 'bar', 'ntubbqcfe', '2021-07-26 23:14:57', '2012-09-17', '1991-03-28 08:31:45.043614', '2002-08-03 13:01:21.005425', -1.23456789123457e+30, 0.123456789123457) ,  (1, 7, 'bar', 'bar', '1992-09-10 10:18:46', '1999-03-26 21:04:57', '1984-07-02 23:59:52.044307', '2015-01-05 04:02:13.014347', -0.123456789123457, 1.23456789123457e+43) ,  (3, 9, 'foo', 'tu', '1991-11-15 08:57:00', '2007-10-19', '2007-08-28 21:26:56', '1975-02-10 06:28:19.000247', 1.23456789123457e-09, 5.86761474609375e+80) ,  (-1180696576, -1417216000, 'ubbq', 'bbqcfebqd', '2007-11-05', '2012-09-22', '2026-03-05 09:03:55.039039', '1997-12-10 21:44:32', 1.23456789123457e+44, -1.23456789123457e+30) ,  (1, 9, 'bqcf', 'qcfebqdwnzfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliww', '1972-10-13 12:48:15', '1991-09-28', NULL, '2015-09-07 10:09:57.049010', 0.123456789123457, -0.123456789123457) ,  (1311309824, -563216384, 'cfebqdwnz', 'febqd', '2015-05-04 07:30:17', '1998-02-21', '1982-04-07 17:32:19.008524', '1973-09-19 10:53:32.011943', 0.123456789123457, -1.23456789123457e+39) ;
INSERT INTO rqg_table1 VALUES  (1, 5, 'bar', 'foo', '1980-06-03', '1982-06-03', '2014-05-24 11:59:27', '2006-04-18 01:19:05.042590', -1.23456789123457e-09, -5.91970023520181e+18) ,  (1, 6, 'ebqdwnzfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqh', 'bar', '2000-08-12 19:30:03', '1984-08-23', '2020-01-03 12:31:18', NULL, -1.23456789123457e+44, -1.23456789123457e+44) ,  (7, 2, 'bqdwnzfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgo', 'bar', '2007-12-23 02:31:18', '1973-05-10 06:33:12', '2032-06-17 00:50:26.044433', '1980-07-13 12:40:56.043651', -1.23456789123457e+43, -1.23456789123457e-09) ,  (0, 8, 'qdwnzfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllis', 'bar', '1985-12-21 05:36:38', '2028-08-27', '1972-01-24', NULL, 8.75302735077127e+18, -1.23456789123457e+39) ,  (8, 3, 'dwnzfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpo', 'bar', '2023-03-04 22:25:32', '1988-10-17 10:33:46', NULL, '1995-05-17 10:35:57.000938', -1.23456789123457e+44, 3.85650634765625e+80) ,  (1, 1, 'wnzfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzsky', 'foo', '1978-07-23 23:59:36', '2011-02-11', '1999-05-06 11:18:47.034116', '1979-08-26 00:19:48.057025', -1.23456789123457e+43, -7.72125244140625e+80) ,  (0, 1, 'nzfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeio', 'bar', '2011-10-12 21:04:51', '1999-10-13 09:18:49', '1990-07-09 04:47:16.063507', '2032-04-13 16:51:14.002431', 1.23456789123457e-09, 1.23456789123457e+39) ,  (1, -648151040, 'foo', 'bar', '1977-11-19 20:01:35', '1990-11-02', '2000-02-03', '1971-05-02 13:07:06.024213', -1.23456789123457e+25, -4.94410796592267e+18) ,  (2, 1, 'foo', 'zfxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfy', '1991-02-05 00:23:53', '1988-05-12 18:05:38', NULL, '1973-09-10', 1.23456789123457e-09, 1.23456789123457e+30) ,  (1, 5, 'foo', 'foo', '2012-01-26', '2010-05-20 13:08:25', '2032-02-04', '2000-05-06 21:47:51.031820', 979697664, -1.23456789123457e+39) ,  (5, 1, 'foo', 'fxsbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzsky', '1995-09-24 22:10:03', '1979-08-07 02:08:16', NULL, '2002-11-14 05:36:07.027092', 0.123456789123457, 0.123456789123457) ,  (-809041920, 1, 'foo', 'xsbztabym', '1984-04-05 07:40:31', '2021-08-05', '2002-11-16 12:13:40.034188', '2032-10-20 20:24:23.034734', 1.23456789123457e+44, 0.123456789123457) ,  (1, 7, 'sbztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevq', 'bar', '2027-07-18 15:31:10', '2018-08-02 21:30:07', '2003-04-08', '2004-05-19 19:50:35.037167', 1.23456789123457e+44, -1.23456789123457e+30) ,  (6, 1, 'bztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlako', 'ztabymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaul', '1975-01-18', '1988-10-01 12:36:56', '2005-05-09 01:57:38.049124', '1993-02-22 15:29:25.029666', 1.23456789123457e+25, 1.23456789123457e+25) ,  (0, 9, 'tabymajfwyeozaurhjod', 'foo', '1989-05-08', '2028-12-04', '2003-02-09', '1991-09-24 12:31:16.015919', 1516961792, 8.8531494140625e+80) ,  (1, 1, 'bar', 'abymajfw', '2003-06-24', '2014-06-17 11:45:16', '2014-02-28 21:46:35.017124', '2000-12-17 13:46:27.050725', -1550450688, -0.123456789123457) ,  (2, 1, 'bar', 'foo', '1987-01-02', '1990-09-17', '1971-03-11 05:02:25', '2012-04-27 05:17:48.053365', -0.123456789123457, -1.23456789123457e+25) ,  (1, 7, 'bar', 'bymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioe', '1974-08-15', '1977-11-22 09:30:25', '2018-04-20 22:54:22.019033', NULL, -3.138427734375e+80, -1.23456789123457e-09) ,  (7, 4, 'ymajfwyeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhm', 'majfwyeo', '2014-08-05', '2012-04-03', NULL, '1971-06-18 00:54:19.059598', -1.23456789123457e+25, 0.329574584960938) ,  (2092761088, 5, 'bar', 'a', '2027-01-09', '2030-09-25', '2027-08-08 06:18:45.026394', '2035-11-10 20:19:56', 1.44706285526948e+18, 1.23456789123457e+39) ,  (7, 0, 'bar', 'bar', '1986-04-20 19:59:48', '1972-01-13', '1977-07-28', '1989-06-25', 1.23456789123457e+44, 1.23456789123457e-09) ,  (0, 2011168768, 'jfwyeo', 'bar', '2011-04-15', '2020-12-01 01:35:39', '1971-03-02', '1982-07-15 15:36:27.016443', 2074083328, -1.23456789123457e-09) ,  (1, 5, 'bar', 'bar', '2029-04-11', '1985-06-09', '1985-08-06 01:09:10.031049', '1982-06-18 13:35:22.029240', -1.23456789123457e+25, 6.4654541015625e+80) ,  (1, -83427328, 'fwyeozaur', 'wyeoza', '2004-05-11', '2025-12-25 07:45:00', '1989-04-19 17:34:23.047808', '1972-05-23 07:23:23.026023', 4.73114013671875e+80, 1.23456789123457e+43) ,  (1366425600, 5, 'bar', 'yeozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenm', '2034-02-28', '2001-11-14 10:38:50', NULL, '2028-06-13 17:46:43.052830', -1.23456789123457e+44, 1.23456789123457e+39) ,  (1, -252837888, 'eozaurh', 'bar', '1991-09-07', '1989-08-28', '1977-08-06 10:38:22', '1975-09-01 00:58:30.023788', 4.77996826171875e+80, 0.463714599609375) ,  (1, 3, 'foo', 'bar', '1988-02-19', '2005-01-18', '2002-07-18 22:09:52.041826', '2014-09-03 19:41:10.020764', -8.29421996899735e+124, 8.4686279296875e+79) ,  (2, 1627652096, 'ozaurhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoi', 'bar', '2016-04-05', '1994-11-11 15:32:21', '1985-05-02 10:25:06', NULL, -4.10461425191712e+124, 1.23456789123457e-09) ,  (5, 0, 'zaurhjoddxorsiytctjynswjnzbncpli', 'aurhjodd', '2017-06-27 07:58:14', '1992-08-21 02:50:53', '1983-04-11 09:53:09', '1981-03-11 09:05:55.003250', 1.23456789123457e+30, 0.874954223632812) ,  (1, 2, 'bar', 'foo', '1993-09-11', '2029-05-28 00:32:01', '2007-02-12 04:26:20.031614', NULL, -6.33797205059384e+18, 1.23456789123457e+44) ,  (1, 623771648, 'bar', 'foo', '2031-05-01', '2010-03-20 19:58:13', '1971-02-03 07:13:24', '1976-04-16 15:45:05', -1.23456789123457e-09, 0.123456789123457) ,  (1, 1, 'u', 'foo', '1972-11-22', '2002-10-08', '2012-07-15 13:30:21', '1988-05-04 21:43:51.063253', 1.23456789123457e-09, 0.773178100585938) ,  (1, 5, 'rhjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmr', 'bar', '1974-09-02 21:25:31', '2001-06-01', '1987-06-21', NULL, 6.61015835307305e+18, 0.2989501953125) ,  (1, -1921122304, 'hjoddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwau', 'joddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlu', '2002-09-27 03:26:05', '1991-09-13', '2007-12-08 23:01:40', '2008-05-08 00:49:43.008167', 1.23456789123457e+30, 1.23456789123457e-09) ,  (1, 1, 'bar', 'bar', '2020-11-11', '1983-11-17 21:15:07', NULL, '1999-12-14 16:16:03.060931', 0.123456789123457, 1.23456789123457e+30) ,  (1, 1431502848, 'od', 'foo', '2009-09-21', '2010-04-25 11:58:04', NULL, '1984-07-05 03:19:04.042907', -1.23456789123457e-09, 4.06196538891148e+18) ,  (-1804140544, 2047672320, 'foo', 'ddxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzkt', '2007-11-02', '2016-06-12 05:47:24', '1971-11-05', NULL, 1.23456789123457e+39, -0.123456789123457) ,  (-660340736, -1824587776, 'dxorsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmh', 'foo', '2029-11-08 15:04:49', '2020-12-06', '2000-01-17 16:29:12.043051', '2027-02-09 16:06:55.042475', 4.931640625e+80, 1.23456789123457e-09) ,  (8, 0, 'foo', 'bar', '1997-07-07 13:02:03', '1994-05-06', '2010-06-28 16:28:10.028556', '2014-10-22', 3.62173852533601e+18, -2.7635192798729e+124) ,  (1921777664, 1768030208, 'bar', 'xorsiytctjynswjnzbncpliwwilaovwnzskywbe', '1975-03-17 21:59:34', '2005-01-17', '2034-12-23 18:56:34.013151', NULL, 1.23456789123457e+43, 1.23456789123457e+43) ,  (-1532297216, 1, 'bar', 'foo', '1978-01-21', '2018-06-22 06:25:37', '2015-01-04 03:45:36', '1990-07-19 08:13:42', 8.21541014525392e+18, -0.123456789123457) ,  (3, 7, 'orsiytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludaw', 'rs', '2016-11-03 11:31:42', '2023-10-19', '1971-05-02', '1995-05-28 06:23:28.037598', 0.123456789123457, 1.23456789123457e+43) ,  (0, 1087832064, 'siytctj', 'foo', '2017-11-22 18:38:31', '2006-10-26 14:23:28', NULL, '2015-12-02 04:28:54', 2.93578400709214e+18, -1.23456789123457e+25) ,  (1, 6, 'iytctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzco', 'ytctjynswjnzbncpliwwilaovw', '2001-03-02', '2028-04-11 00:27:21', '1977-09-06 14:28:57.016550', NULL, 0.123456789123457, -7.70312568764052e+18) ,  (-1625161728, 1, 'tctjynswjn', 'ctjynswjnzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvu', '1974-05-24 02:32:27', '1981-09-12 22:05:12', '2004-04-13 01:23:25.030720', '2024-02-08 07:24:55.008650', -1.23456789123457e+39, -9.5132446284195e+124) ,  (-214302720, 1, 'foo', 'tjynswjnz', '1977-03-05', '2024-05-07', '2009-10-10 00:24:27.018251', '1987-02-15 04:17:08', -1.23456789123457e+30, 8.17628512349114e+18) ,  (9, 2, 'bar', 'jynswj', '1994-09-11', '1998-01-15 02:51:05', '2013-05-24 06:06:41.003843', NULL, 1.23456789123457e+44, 1.23456789123457e+43) ,  (6, 7, 'bar', 'bar', '2030-01-23 05:09:24', '1984-12-02 07:17:34', '1974-05-22 17:37:38.029007', NULL, 1.23456789123457e+44, -0.123456789123457) ,  (1, 264241152, 'bar', 'ynswjn', '1980-03-04', '1988-10-23 09:26:41', '1984-06-24 22:07:53.017436', '1972-10-16 13:24:03.000161', 3.21528865896582e+18, 1.23456789123457e+30) ,  (1, 2, 'nswjnz', 'swjn', '1996-04-17 16:53:34', '2010-10-18 22:10:46', '2015-02-19 06:25:28.027395', '2007-07-13 12:32:32.026898', 1.23456789123457e-09, 0.123456789123457) ;
DROP TABLE if exists rqg_table2 cascade;
CREATE TABLE rqg_table2 (
c0 int,
c1 int,
c2 text,
c3 text,
c4 date,
c5 date,
c6 timestamp,
c7 timestamp,
c8 numeric,
c9 numeric)   distribute by replication;
CREATE INDEX idx_rqg_table2_c1 ON rqg_table2(c1);
CREATE INDEX idx_rqg_table2_c3 ON rqg_table2(c3);
CREATE INDEX idx_rqg_table2_c5 ON rqg_table2(c5);
CREATE INDEX idx_rqg_table2_c7 ON rqg_table2(c7);
CREATE INDEX idx_rqg_table2_c9 ON rqg_table2(c9);
INSERT INTO rqg_table2 VALUES  (5, 1, 'wjnzbnc', 'j', '2032-07-05 01:37:04', '1982-12-07', '2008-11-09 11:48:18', '2007-03-05 00:03:35.002803', -5.25787353041413e+124, -1.23456789123457e+25) ,  (2, 1, 'nzbncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaul', 'bar', '2000-01-15', '1990-09-05', '1972-02-16 11:34:27.052700', '2012-08-23 08:30:16.006438', 0.934555053710938, -5.62949953421312e+15) ,  (6, 1, 'bar', 'zbncp', '2012-02-14 06:48:47', '1978-03-23 20:23:38', '2026-06-17 08:15:16.065290', '1989-11-06 12:11:22.015467', 0.123456789123457, 1.23456789123457e+39) ,  (-230359040, 7, 'bncp', 'ncpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplie', '1975-04-25', '1977-05-18', '1990-04-08 17:21:54.013576', '2024-11-06 00:25:00.018912', 0.123456789123457, -6.28336590511197e+18) ,  (1, 0, 'foo', 'bar', '2005-08-02 13:52:37', '2023-02-26 13:23:13', '2026-02-18 23:00:59.037721', '2000-06-03 22:00:17.016532', 0.123456789123457, -1.23456789123457e+39) ,  (8, 1838940160, 'cpliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferve', 'foo', '2013-02-28', '2034-08-04', '1985-08-11 08:06:49', '1985-09-11 11:05:53', -1.23456789123457e+30, 1.23456789123457e-09) ,  (1448411136, 1, 'bar', 'foo', '1983-02-11', '1975-01-20', '2016-08-08 14:08:46.052546', '1997-12-05 03:30:02', -1.23456789123457e+25, -5.04913329583038e+124) ,  (9, 2, 'pliwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmr', 'liwwilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgos', '1976-08-24 02:50:01', '2022-07-27 04:17:17', '2011-04-19 17:21:10.048932', '2023-12-12', -1.23456789123457e+25, 3.4759521484375e+79) ,  (3, 1, 'foo', 'bar', '1985-01-28 22:00:57', '2033-08-25', '2019-03-22 11:53:29.029685', '2025-05-18 07:32:27.012057', 1.23456789123457e+43, -0.123456789123457) ,  (6, 8, 'iwwilaovwn', 'w', '1980-01-04', '2021-04-22 10:55:20', '2027-06-16 11:24:03.038540', '1982-02-10 04:23:21.043093', -1.23456789123457e+44, -1.23456789123457e+43) ,  (6, 983629824, 'wilaovwn', 'ilaovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzk', '1978-03-07', '2016-07-20 21:45:23', '1996-01-13 19:34:17.065027', '1979-09-25 10:09:10', 1.23456789123457e-09, 1.23456789123457e+43) ,  (1, -1143341056, 'laovwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdsl', 'aovwn', '2015-06-12', '2029-10-01', '1982-05-08 14:08:54.030254', NULL, 1.23456789123457e+30, -0.123456789123457) ,  (2103836672, 2, 'ovwn', 'vwnzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosg', '2018-09-12 15:01:50', '1992-09-24 14:51:26', NULL, NULL, 0.34423828125, 337510400) ,  (9, 1, 'wn', 'nzskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcsl', '1984-10-06 11:07:24', '1991-09-04 12:57:58', '1979-12-22', '1976-12-10 12:31:48.060899', -1.23456789123457e+39, -1.23456789123457e+39) ,  (2, 7, 'zskywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsu', 'foo', '1983-06-13 02:47:36', '2021-07-02 07:15:58', '1981-10-03 17:48:19.045819', '1992-07-18 08:43:38', -1.23456789123457e-09, -1.23456789123457e+25) ,  (2, -934019072, 'bar', 'skywbeupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuq', '1976-10-16', '1991-01-14 16:57:14', '1976-10-21 18:49:29.057934', NULL, 8.02316273616054e+18, -543752192) ,  (1, 0, 'bar', 'bar', '2023-03-04', '1976-11-27 20:02:57', '1994-02-16 10:23:34.017065', '2019-08-19 05:20:25.022609', -1.23456789123457e+44, 1.23456789123457e-09) ,  (1, 1165099008, 'bar', 'ky', '1988-06-12 15:20:12', '1985-06-02 06:21:52', '2027-01-09 02:16:31', '1976-10-27 14:57:42', 5.8324429924215e+18, -1383858176) ,  (1, 1, 'ywbeupnlqnxfykwpllisxyeohbkmthl', 'wbeupnlq', '2020-06-20 04:09:17', '1998-07-28', '1974-04-06 11:34:04.051313', '2024-02-15 20:27:33.040429', -1.23456789123457e+30, 1.23456789123457e-09) ,  (3, 1, 'bar', 'beupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktf', '1994-01-20 14:16:43', '2010-10-08', NULL, '1988-11-18 10:55:54', -1.23456789123457e+39, -0.123456789123457) ,  (5, 1, 'eupnlqnxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkw', 'upnlqnxfykw', '1986-09-16 04:55:40', '1990-07-22', '2026-07-22 04:10:48.031359', NULL, -1.23456789123457e+25, 1.23456789123457e+30) ,  (1, 1, 'foo', 'bar', '2010-03-16', '2022-05-09 09:01:09', NULL, '2031-03-20 07:32:05', 1.23456789123457e-09, -1.23456789123457e+39) ,  (1, 997720064, 'pnlqnxfyk', 'bar', '2035-11-04', '2030-08-08', '2013-05-18 23:22:43.023701', NULL, -0.123456789123457, 1.23456789123457e-09) ,  (4, 1, 'nlqnxfyk', 'lqn', '1995-07-16 12:03:13', '2009-11-06 16:30:54', '2030-06-13 01:49:21.048204', '1976-10-12', 1.23456789123457e+25, -1.23456789123457e-09) ,  (56950784, 1, 'qnxfy', 'bar', '2011-10-10', '2005-11-19', NULL, '2005-03-17 02:55:58.045420', 1.23456789123457e+43, 5.84381103515625e+80) ,  (-1282736128, 3, 'nxfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttg', 'xfykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenm', '2019-08-25 03:31:44', '2014-04-07', '1992-01-21 08:15:06.012997', '1975-02-01 21:17:34.026176', -1.23456789123457e+43, 1.23456789123457e+44) ,  (3, 2, 'fykwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzj', 'foo', '1991-06-15', '2033-04-04', '1975-02-20 22:46:11.044200', '1981-07-01', 1.23456789123457e+39, -1.23456789123457e+39) ,  (-1250820096, 3, 'ykwpll', 'bar', '2029-08-15', '1983-01-22', '2003-06-24 07:31:34.010981', '1973-11-06 10:14:39.049527', -1.23456789123457e-09, -1.23456789123457e-09) ,  (2, 1, 'kwpllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrho', 'foo', '2024-05-07 17:05:03', '1989-03-28', '1983-12-22 10:13:16.010890', '1972-07-19 09:13:31.061929', -1.23456789123457e+44, -1.23456789123457e-09) ,  (1592328192, -70844416, 'wpllisxyeohbkmthlulpmytwbzkmhoqhp', 'bar', '2022-05-25 15:15:37', '1990-04-16 08:22:57', '2030-10-24 11:31:20.061209', '2029-05-24 09:50:02.002354', 0.123456789123457, -1841758208) ,  (9, 67829760, 'foo', 'foo', '2030-10-01', '2019-06-09', '2018-07-02', '2017-09-23 11:33:53', -0.123456789123457, 1.23456789123457e+44) ,  (6, 3, 'bar', 'foo', '2015-09-11', '1981-07-08 18:58:29', '2003-10-28', NULL, -1.23456789123457e-09, 0.001861572265625) ,  (1, 2, 'pllisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeio', 'llisxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuq', '1981-01-27', '2004-03-11', '1993-08-07 23:06:21.012690', '1988-05-28 17:34:40', -1.23456789123457e+44, 1.23456789123457e+30) ,  (6, 1, 'foo', 'lisxyeohbkmthlulp', '2025-02-12', '2010-12-02 16:23:50', '2010-11-01 03:09:47.039450', '2001-08-15 05:36:35.054876', -1.23456789123457e+39, -1.23456789123457e+30) ,  (6, 1, 'isxyeohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioe', 's', '1997-08-09', '2006-06-05 10:46:07', NULL, '1988-01-03 22:31:04.015800', 1.23456789123457e+30, -1.23456789123457e-09) ,  (8, -693960704, 'xy', 'yeohbk', '1972-01-11', '2020-09-09', '2013-11-06 04:30:03.056235', '2031-12-14 16:01:12.000585', -5.48003632157976e+18, 1.23456789123457e+25) ,  (1, -1688076288, 'eohbkmth', 'ohbkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceaty', '1988-04-05', '2008-09-12 23:07:47', '1971-12-06 14:45:37.010514', NULL, -0.123456789123457, -1.23456789123457e+25) ,  (5, 7, 'foo', 'foo', '2007-04-24 18:29:21', '1988-06-10', '1988-06-13', '2028-01-16 01:54:41.030343', 0.123456789123457, -4.62407091740266e+18) ,  (5, 9, 'hbkmth', 'bkmthlulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafz', '2028-09-07 01:13:12', '1975-09-28', '2020-06-23 02:00:20', '2013-11-21 17:50:25.003838', -1.23456789123457e+44, -1.23456789123457e+44) ,  (1, 2, 'kmt', 'foo', '1989-08-02', '1980-07-26', '1997-04-09 19:59:49.034189', '2020-05-27 03:35:02.055628', -1.23456789123457e+39, 0.914825439453125) ,  (1, 5, 'mthlu', 'thlu', '2015-10-26', '2016-02-10 02:57:08', '1996-02-14 09:05:28.059674', '1984-02-26 12:54:14.051223', 1304494080, 0.123456789123457) ,  (5, 1, 'hlulpmytwb', 'lulpmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsc', '2033-09-12', '1992-05-20', '1997-03-26 01:41:56', '2017-11-12 04:20:21', 1.23456789123457e+43, 1.23456789123457e+43) ,  (2140667904, 1, 'bar', 'foo', '2028-02-01', '1990-02-21', '2002-06-05', '2020-04-24 10:53:35.054136', -1.23456789123457e+30, -1.23456789123457e+30) ,  (1, 0, 'bar', 'foo', '1991-03-05 23:10:29', '2013-01-10', '1971-10-10 21:58:33', '2022-01-05 12:31:34.057072', -1.23456789123457e+43, 1.23456789123457e+39) ,  (3, 1, 'ul', 'foo', '2029-04-05 23:33:42', '1978-01-12', '2009-08-19 08:04:58.003743', '2006-04-18 18:02:18', -5.98106178012473e+18, -1164378112) ,  (7, 2, 'l', 'pmytwbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijs', '2001-06-16', '1984-05-24', '2001-05-25 16:10:58.045465', NULL, 1.23456789123457e+39, 1.23456789123457e-09) ,  (8, 6, 'mytwbz', 'ytwb', '2008-05-23 05:03:55', '1973-04-12 10:37:24', '2015-07-11 23:59:35.049047', NULL, 1.23456789123457e+43, -1.23456789123457e-09) ,  (1, 1, 'bar', 'twbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioext', '2003-10-28', '1980-06-21 22:06:11', '2010-04-24 20:29:48.051501', '1985-10-18 07:35:33.040235', 0.123456789123457, 0.123456789123457) ,  (9, 1340473344, 'bar', 'bar', '2004-03-25', '1987-11-18', '1995-11-09', '2028-03-05', 6.93216572643004e+18, 0.300323486328125) ,  (9, 330235904, 'foo', 'wbzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbz', '1988-04-22 05:40:20', '1990-01-04', NULL, '2031-08-06 16:12:48.028751', 1.23456789123457e+30, -1.23456789123457e+44) ;
INSERT INTO rqg_table2 VALUES  (1339359232, 1, 'foo', 'bzkmhoqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfi', '1979-01-06', '2029-07-17', '1987-10-03 13:01:36.059007', NULL, 1.23456789123457e+25, 0.123456789123457) ,  (1712979968, -1850343424, 'bar', 'foo', '2015-12-27 14:46:57', '2030-09-23', '1995-11-05 06:03:31.043565', '1978-10-11 19:58:32.010894', -0.123456789123457, -4.79400634245026e+124) ,  (3, 1, 'zkmh', 'kmhoqhplie', '1973-11-23', '2004-01-09 05:23:43', NULL, '1998-02-03 10:27:42.030584', -1.23456789123457e+25, 1.23456789123457e+25) ,  (3, 1, 'mhoq', 'foo', '1976-02-06 09:06:04', '2000-04-03 01:10:06', '1981-04-16 11:10:21.061935', NULL, 2.35321044921875e+80, -1.23456789123457e+39) ,  (1, 1, 'hoqhplieunvqrsxuqkmrhmpoigmcenmhk', 'oqhplieunvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsufl', '2035-01-27', '1987-05-26 11:15:47', '1996-02-01 01:57:21.008875', '2000-04-25 01:45:36.050796', 1.23456789123457e+30, -1.23456789123457e+25) ,  (2, 1, 'bar', 'q', '1994-12-01', '2000-02-17 06:44:01', '1988-12-26 13:32:07.040608', '1994-11-24 04:05:27', -1.23456789123457e-09, -1.23456789123457e+30) ,  (1, 1, 'hp', 'bar', '1985-11-11', '2015-07-12', NULL, '1991-12-12', -1.23456789123457e+44, 0.0261383056640625) ,  (1, 1, 'plieunvqrsxuqkmrhmpoi', 'lieunvqr', '1971-06-10 05:57:01', '1976-06-11', '2026-07-03', '2025-03-24 06:45:08.011846', -1.23456789123457e+25, 1.23456789123457e+30) ,  (-2119434240, 1, 'ieunvqr', 'eunvq', '2008-04-24 06:47:21', '1983-10-13', '1973-07-23 16:31:58.006348', '2012-01-01', 0.123456789123457, -0.123456789123457) ,  (9, 9, 'foo', 'bar', '1988-08-13 21:48:54', '2032-11-12 10:29:46', '1984-08-20 17:06:45', '1999-09-26 11:36:34.003016', -1.23456789123457e+39, -0.123456789123457) ,  (9, 1, 'foo', 'foo', '1977-07-01', '1990-09-01 01:56:53', NULL, NULL, -1.23456789123457e+44, -1.23456789123457e-09) ,  (2, 1, 'foo', 'bar', '2017-07-15 21:40:50', '1979-03-09 05:41:40', '1982-04-18 15:46:18', '1985-03-25 19:04:34.058102', -1217986560, -0.123456789123457) ,  (7, 3, 'bar', 'foo', '1992-04-14 11:23:17', '2028-05-06 10:23:57', '1989-06-13 00:33:19', '1978-04-01 04:18:12.047714', 1.23456789123457e+25, -8.96316528216629e+124) ,  (-212140032, 2, 'unvqrsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzc', 'nv', '1990-09-23', '2019-10-18 18:10:56', '1998-05-19 18:04:26', '2020-09-13 08:11:09.020216', 1.23456789123457e+30, -1.23456789123457e+30) ,  (3, -410189824, 'foo', 'vqrsxuqkm', '2011-04-03 06:49:55', '2021-02-20 23:55:33', '1995-07-04', '1994-04-16', 0.1307373046875, 1.23456789123457e-09) ,  (-756940800, 4, 'qrsxuq', 'bar', '1972-12-05 15:45:39', '2006-02-09', '2031-10-19 04:44:47.004015', NULL, -1.23456789123457e+30, -7.43628740971882e+18) ,  (3, 1, 'rsxuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjc', 'bar', '2018-08-04 16:19:44', '1987-03-11', NULL, '2000-08-19', 1.23456789123457e+39, -4.12754905848506e+18) ,  (5, 1, 'bar', 'bar', '2022-09-15 11:30:33', '2005-07-21', '1974-02-10', NULL, 1.23456789123457e-09, -1.23456789123457e+43) ,  (121503744, 572129280, 'sxuqkmrhmp', 'xuqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtok', '1980-07-09', '2026-09-09', '2023-11-28', '1972-03-06 19:09:17.035177', -8.39996328730622e+123, -1.23456789123457e+25) ,  (586153984, 1, 'uqkmrhmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwc', 'qkmrhm', '2017-07-01 16:45:59', '2008-11-02', '1998-05-15 22:07:30.055733', '1991-12-18 04:43:50', -1.23456789123457e+30, 1.23456789123457e-09) ,  (1, 0, 'kmrhmpoigm', 'mrhmpoig', '1996-03-02 16:34:25', '2010-06-21', NULL, '2030-09-08 02:18:22.013367', -0.123456789123457, 1.23456789123457e+44) ,  (1, -1009123328, 'rhmpoig', 'bar', '2020-08-27', '2027-01-22', NULL, '2028-02-20 22:18:36.049762', 0.194000244140625, -1.23456789123457e+43) ,  (3, 3, 'hmpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveon', 'mpoigmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtokn', '2001-08-16 02:37:34', '2005-07-20', '2003-10-19', '2023-01-06 10:40:23.043812', 0.123456789123457, -6.45140646620824e+18) ,  (8, 7, 'poigm', 'oigmcenm', '1980-03-25', '1984-05-26 14:19:02', '2019-03-13 08:35:41', '2021-08-18 01:06:31', -7.81646728515625e+80, -1.23456789123457e-09) ,  (0, 1, 'bar', 'bar', '2013-11-05', '1984-03-03 04:47:40', NULL, '2000-10-06 07:46:20', 1.23456789123457e+44, 0.123456789123457) ,  (9, 5, 'bar', 'foo', '1996-01-24 03:02:49', '1995-11-04', NULL, '1984-06-03 21:37:49.051511', 1.23456789123457e+44, 1.23456789123457e-09) ,  (4, 680394752, 'foo', 'bar', '1982-10-20', '1978-05-09 10:47:33', '1973-01-18 00:24:42.014812', '2030-09-15 06:59:16.029949', -1.23456789123457e+30, 1.23456789123457e-09) ,  (1, -177143808, 'foo', 'igm', '1971-06-06 20:34:36', '2003-02-13 13:25:05', '1973-07-11 11:16:01.026638', '2012-04-14 00:11:07.025737', -1.23456789123457e+25, -754647040) ,  (1, -445448192, 'bar', 'bar', '1998-10-22 13:08:31', '1992-10-06', '2010-12-03 11:09:52', NULL, 1.23456789123457e+44, -1.23456789123457e+43) ,  (0, 1, 'gmcenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferve', 'bar', '2006-12-20', '2032-08-24 04:43:47', '2013-08-14', '1977-08-21 20:47:16.022803', -1.23456789123457e+39, -1.23456789123457e-09) ,  (1, 4, 'mcen', 'cenmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferve', '1986-12-02', '2010-02-09 00:42:13', '1981-03-28', '2018-10-17 15:12:28.014053', 1.23456789123457e+30, -1.23456789123457e+30) ,  (2, 8, 'enmh', 'bar', '2002-01-18 07:23:07', '1994-04-18', '1972-10-17 22:51:48', '1979-06-18 07:23:58', 1.23456789123457e+43, -2.35504149626129e+124) ,  (1, -17956864, 'nmhkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttg', 'foo', '2016-09-21 14:57:20', '2022-10-24 06:22:57', '1993-08-27', NULL, 0.123456789123457, 1.23456789123457e-09) ,  (3, 689373184, 'bar', 'bar', '1971-12-18 01:20:20', '1977-03-23', NULL, '2008-06-27 00:16:41.001861', -0.123456789123457, -1.23456789123457e+43) ,  (-1257242624, 2032336896, 'bar', 'bar', '2013-02-15 13:01:37', '1996-12-06 22:51:57', '1982-10-01 15:19:50', '1982-12-09 09:19:57', 1478295552, -1.23456789123457e+39) ,  (3, 1, 'mhkgosggsc', 'hkgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeup', '2023-09-24', '1979-12-14', '2024-03-17 23:55:10', '1977-07-05 08:57:09', 9.73724365234375e+80, -1.23456789123457e+43) ,  (1, 1, 'foo', 'kgosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzkt', '2024-04-03', '2032-01-17', NULL, '2023-01-01 22:12:08.034323', 0.123456789123457, -1.23456789123457e+39) ,  (5, 3, 'bar', 'gosggsctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeu', '1990-12-15 04:29:44', '1989-12-11', '2021-10-23 13:20:43.061902', NULL, 0.123456789123457, 1.23456789123457e+25) ,  (19791872, 7, 'foo', 'foo', '2006-04-23 01:44:34', '1992-07-20', '2011-10-03 14:28:02.063533', '1997-06-04 06:38:41.056836', 6.06803754792832e+18, 1.23456789123457e+30) ,  (1786642432, 7, 'osgg', 'bar', '1994-11-24 04:22:50', '1989-09-20 03:12:04', '1987-04-17 08:30:16.000544', NULL, 0.123456789123457, -1.23456789123457e+39) ,  (0, 1, 'bar', 'foo', '2013-04-02 23:14:23', '1990-03-14 07:13:55', '2018-06-24 18:17:49.057004', '2029-05-21', 1.23456789123457e+43, 1.23456789123457e+43) ,  (6, 1, 'foo', 'bar', '2033-11-02', '1985-01-11 04:09:27', '2000-12-03 01:25:43.017973', '2001-04-02 19:11:54', -1.23456789123457e+43, 0.050506591796875) ,  (-273481728, -745734144, 'sgg', 'foo', '2006-03-05 21:55:49', '2006-02-22 20:53:59', '1985-12-27', '2026-08-11 14:47:00', 1.23456789123457e+39, -0.123456789123457) ,  (7, 587071488, 'ggsctlakolevqxuzconeioext', 'gsct', '2018-02-03', '1979-02-14', '1994-10-19 16:36:17', '2034-10-23 12:04:05.054690', -1.23456789123457e+44, 0.0627593994140625) ,  (1, 1, 'sctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznfe', 'bar', '1999-03-06 11:07:06', '1972-12-05', NULL, NULL, -1.23456789123457e+30, 1.23456789123457e+30) ,  (5, 1, 'ctlakolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvq', 'tlakolevq', '1999-06-26 21:03:46', '1986-05-11 16:58:42', NULL, NULL, -1.23456789123457e+25, -0.123456789123457) ,  (6, 5, 'foo', 'lakolevqxu', '2027-09-14', '2024-11-03', '1976-02-04 18:47:08.050942', '1978-07-03 15:46:52.044351', -1.23456789123457e-09, 1.23456789123457e+30) ,  (1232994304, -579010560, 'foo', 'a', '2008-02-15 18:05:56', '2023-05-25', '1980-05-21 17:27:35', '2014-08-24', 1.23456789123457e+30, 1.23456789123457e+44) ,  (7, 1627521024, 'kolevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjq', 'olevqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbt', '2021-06-28 11:28:58', '2026-09-22', '2024-10-13', '2002-12-23', -1984167936, -3.7745794376899e+17) ,  (1, 3, 'levqxuzconeioextuvulhndsgijsufla', 'foo', '1995-06-11 09:48:14', '1984-11-22 02:05:45', '2007-12-27 03:12:32.052068', '1984-10-11', -3.28903510286402e+18, 1098645504) ;
DROP TABLE if exists rqg_table3 cascade;
CREATE TABLE rqg_table3 (
c0 int,
c1 int,
c2 text,
c3 text,
c4 date,
c5 date,
c6 timestamp,
c7 timestamp,
c8 numeric,
c9 numeric)    PARTITION BY hash( c9) ;
create TABLE rqg_table3_p0 partition of rqg_table3 for values with(modulus 2,remainder 0);
create TABLE rqg_table3_p1 partition of rqg_table3 for values with(modulus 2,remainder 1);
CREATE INDEX idx_rqg_table3_c1 ON rqg_table3(c1);
CREATE INDEX idx_rqg_table3_c3 ON rqg_table3(c3);
CREATE INDEX idx_rqg_table3_c5 ON rqg_table3(c5);
CREATE INDEX idx_rqg_table3_c7 ON rqg_table3(c7);
CREATE INDEX idx_rqg_table3_c9 ON rqg_table3(c9);
INSERT INTO rqg_table3 VALUES  (2, 1, 'evqxuzcon', 'bar', '2015-06-10', '1972-04-14', '2020-01-04', '1997-06-08', -1.23456789123457e+43, 6.61651611328125e+80) ,  (2, -2093940736, 'foo', 'vqxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrh', '1980-06-14', '1995-10-17 19:22:52', '2001-08-04', '1976-11-12 09:41:25.030327', 1.23456789123457e+43, 1.46310692894199e+18) ,  (7, 9, 'foo', 'foo', '2033-11-23', '2017-02-09 00:40:27', '1996-01-15 15:47:11.058318', '1983-09-27', -6.36367797487931e+124, 0.123456789123457) ,  (5, 8, 'bar', 'foo', '2018-05-28', '2031-04-11 06:51:22', '1974-10-08 00:31:47', '1995-07-03', 1452343296, -1.23456789123457e+30) ,  (7, 1, 'qxuzconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupigm', 'bar', '1983-07-12', '2010-02-21 14:05:43', '2034-04-07', NULL, 1.23456789123457e+30, 1.23456789123457e+44) ,  (3, 2, 'x', 'uzc', '1995-07-17', '2025-09-18 21:46:45', '2026-06-07 15:45:38', '2034-03-22', -1.23456789123457e+30, -1.23456789123457e+30) ,  (1, -39714816, 'zconeioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjci', 'bar', '1993-03-11 00:59:32', '1975-04-10 16:52:59', '1972-06-10 16:27:23.051629', '1977-09-09', 1.23456789123457e-09, 1.23456789123457e+25) ,  (3, 1, 'cone', 'oneioex', '1980-03-07 01:01:38', '2032-06-27', '2005-02-20', '1990-10-25 22:16:49.031175', 1.23456789123457e-09, -7.11315413645499e+18) ,  (1, 6, 'bar', 'bar', '2011-12-08 14:00:58', '2035-04-12 20:11:01', '2006-04-02', '1994-06-16 14:02:58.009541', 1.180419921875e+80, -8.63424491059937e+18) ,  (9, 1, 'neioextuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxw', 'bar', '2033-05-02', '1992-02-12', '1991-09-17 07:09:50.054832', '2015-09-05 06:13:57', 1.23456789123457e+30, -1.23456789123457e+43) ,  (1, 894828544, 'bar', 'eioextuvu', '1999-06-20 20:27:12', '1971-06-09 01:54:23', '2009-04-12', NULL, 0.123456789123457, -0.123456789123457) ,  (1, 1, 'bar', 'ioe', '1985-05-15', '1984-01-25 09:46:17', '2024-04-21 21:06:12.018819', '1980-04-24 03:21:21.059658', 1.23456789123457e+25, -1.23456789123457e+43) ,  (1, -844890112, 'oextuv', 'extuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupigmm', '1995-08-02', '2012-10-21', '2030-11-19 04:58:57.046531', NULL, -1.23456789123457e+44, -0.123456789123457) ,  (0, 8, 'bar', 'foo', '2027-06-18', '2000-02-28 04:22:05', '1993-08-11 19:43:31.022180', '1973-04-28 15:04:00.057450', 1.23456789123457e+44, 0.123456789123457) ,  (4, 8, 'xtuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbd', 'bar', '2006-03-10 09:17:48', '2011-01-15 13:37:20', '2012-12-14 04:28:55.019012', '2013-10-09 11:52:28.054794', 0.123456789123457, 0.123456789123457) ,  (-1500184576, 1, 'foo', 'bar', '2025-11-01 02:06:14', '1979-11-04', '1995-09-28 00:39:02.006547', '2009-03-17 11:31:45.034236', 0.123456789123457, -1.23456789123457e+44) ,  (9, 1, 'tuvulhndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrho', 'bar', '1989-03-11 04:50:39', '1998-06-21 16:28:54', '2018-08-22 09:45:26.003263', '2017-07-18 12:02:35.006328', -6.83984193406894e+16, -565248000) ,  (1306591232, 2, 'foo', 'bar', '2018-02-22', '2006-07-28', '1998-01-28 13:10:57', '2029-03-12 20:31:26.048288', 1.23456789123457e-09, 1.23456789123457e-09) ,  (1, 1, 'uvulhn', 'v', '1974-09-22 09:04:50', '2012-05-06 11:36:02', '1996-08-15 03:46:24.012467', '1976-07-18 11:22:08.000282', 1.23456789123457e+30, -9.17889899053449e+17) ,  (1, 8, 'ulhn', 'foo', '1983-02-17', '1989-11-12 23:47:15', '2028-03-03 08:54:29.061966', '1997-12-11 14:44:39.062016', -1.23456789123457e+39, -1.23456789123457e+25) ,  (1, 9, 'bar', 'foo', '2035-08-17', '1976-08-21', '2023-09-18 00:53:41.022370', NULL, 1.23456789123457e+44, -1.23456789123457e+30) ,  (1, 792657920, 'bar', 'bar', '1985-12-02', '1975-01-28', '1999-02-20 05:45:58.057898', '2025-03-12', -1.23456789123457e+44, 3.61114501953125e+80) ,  (-1795293184, 1, 'foo', 'foo', '1987-03-28', '1991-12-10', '2018-04-20 01:36:05.052742', NULL, -0.123456789123457, 0.353530883789062) ,  (-1659633664, 5, 'bar', 'lh', '2010-03-24 18:49:30', '1988-03-02', '2005-12-02 04:48:52', '2008-01-22 11:13:00.044616', 1.23456789123457e+39, -1.23456789123457e-09) ,  (1, 6, 'foo', 'bar', '2012-08-10 17:52:21', '1983-02-10', '2015-01-28 00:16:39.002881', '2006-11-20 15:42:03.020716', 1.23456789123457e+39, 1.23456789123457e-09) ,  (-1278214144, -1982595072, 'hndsgijsuf', 'bar', '2031-05-07 17:38:58', '2029-07-26 06:03:55', '1982-02-01 20:16:38.029803', '2006-04-21 18:12:44.037853', -1.23456789123457e-09, -1.23456789123457e+44) ,  (8, 792133632, 'bar', 'ndsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczm', '1990-05-27 02:48:07', '2027-01-18', '1979-05-11', '1975-03-07 08:09:39.054264', -1.23456789123457e+44, -1.23456789123457e+44) ,  (2, 1, 'dsgijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveon', 's', '1998-03-01 08:44:52', '1987-06-27', '2008-02-26', '2012-11-22', 0.11798095703125, 1.23456789123457e-09) ,  (0, 1, 'bar', 'bar', '2024-02-14', '2016-06-25 23:22:55', NULL, '2006-01-24 11:59:22.040676', 1.23456789123457e+39, 0.123456789123457) ,  (8, 5, 'gijsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibm', 'bar', '1980-11-28 14:05:56', '1990-03-15', '1989-05-08', '1983-12-02', -898826240, 1985150976) ,  (-327483392, 136642560, 'bar', 'bar', '2029-03-14', '2002-03-03 05:52:37', '1999-12-04', '2028-10-12 18:23:00.037229', 7.87932902306139e+18, 0.677459716796875) ,  (9, 1, 'foo', 'i', '2025-04-25', '1977-04-12', NULL, '2015-04-20 08:06:50.015783', -1.23456789123457e+43, 1.23456789123457e+25) ,  (0, 318242816, 'jsuflajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhv', 'bar', '2013-03-28', '2001-05-24', '2033-03-28 23:43:15.058541', '2028-08-12 03:00:16.024713', -0.123456789123457, 1.23456789123457e-09) ,  (1, 2, 'suflajn', 'u', '2024-01-07', '2022-04-16', '1987-05-28', '1997-05-11 15:19:19.013980', -1.23456789123457e+39, 0.396697998046875) ,  (1, 1, 'foo', 'bar', '1975-04-09 17:03:41', '1971-07-17', '2001-06-20 06:37:17', '2005-11-19 22:35:25.024350', 4.52780647536761e+18, 1.23456789123457e+43) ,  (1, 7, 'flajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjci', 'foo', '1993-02-22 09:39:25', '2013-10-26', NULL, '2004-09-20 11:32:30', -8.15368652159119e+124, -9.83413696272477e+124) ,  (1, -1127546880, 'bar', 'lajnedgesg', '2029-09-26', '2006-10-07', '1982-03-24', '1987-01-21 21:14:24.041216', 1.23456789123457e+43, 2.59002685546875e+80) ,  (1, 1, 'ajnedgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyh', 'jnedges', '2007-03-24', '2003-09-25', NULL, '1984-09-03 11:33:06.007934', -0.123456789123457, 1.23456789123457e+25) ,  (626130944, 5, 'bar', 'nedgesgkwaullafzktfd', '1974-11-25', '2002-07-06', '1993-05-26 17:12:46.016731', '1991-02-17 17:03:11', 202113024, -1.23456789123457e-09) ,  (6, 1, 'edgesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcs', 'dgesgk', '1997-01-12', '2000-06-14 10:40:20', '2002-11-23 15:15:45.033024', '2011-08-22 11:03:59', 1.23456789123457e-09, 1.23456789123457e+30) ,  (-1280704512, 1358168064, 'gesgkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypa', 'bar', '2019-11-07 11:12:18', '1989-11-28 17:22:26', '1972-06-13 23:25:14.054456', '1977-04-04 22:08:00.000659', 0.123456789123457, -0.123456789123457) ,  (7, 557645824, 'foo', 'foo', '1979-02-20', '1992-05-21', '2027-10-27', '1999-10-21 01:06:23.017027', 1.23456789123457e-09, 1.23456789123457e+25) ,  (5, -1711800320, 'e', 'sgk', '1979-06-01', '2006-06-28 03:16:05', '1996-10-27 06:19:21.019734', '1989-12-12 14:16:30.032267', -711458816, -1.23456789123457e+25) ,  (-2075262976, 2, 'gkwaullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyr', 'kwaullafzktfdxb', '2009-09-23 12:51:56', '2009-12-20', '2013-11-08 17:31:02.045888', '2023-01-05 20:59:54', 1.23456789123457e+44, 0.123456789123457) ,  (1, -1318322176, 'bar', 'foo', '2014-04-16', '2018-01-09', '2032-06-17 20:15:34.032626', '1991-02-07 10:45:12', 0.123456789123457, 1.23456789123457e+25) ,  (8, 1, 'bar', 'waul', '2024-10-13', '1989-04-12', '2011-07-28 19:43:46.010735', '1981-04-20', -7.46612375725015e+18, -8.4123229964592e+124) ,  (1, 7, 'aullafzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyc', 'bar', '2033-07-16 23:04:13', '2010-01-24', '2019-07-20 18:13:16', '2034-10-27 04:48:41.060902', 1.23456789123457e+39, 0.143539428710938) ,  (-1373306880, 3, 'ullafzktf', 'll', '1974-03-06 15:36:17', '1982-04-11', '1998-07-21 21:53:31.046169', '1981-04-22 10:56:02.054553', 2.88117786161027e+18, 0.849380493164062) ,  (6, 1, 'lafzktfdxb', 'foo', '2000-03-03', '2002-08-04', NULL, '1984-07-24', 1.23456789123457e+39, -8.11767577936768e+124) ,  (1, 1, 'foo', 'foo', '2022-03-17', '1982-04-28 10:16:56', NULL, '1976-03-02', 0.123456789123457, 276627456) ;
INSERT INTO rqg_table3 VALUES  (1, 1, 'afzktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzh', 'foo', '2031-01-27 22:41:25', '1998-03-15', '2008-12-13 03:55:37', NULL, 1.23456789123457e+39, 1.23456789123457e+43) ,  (0, 5, 'fzktfdxbz', 'bar', '1976-07-14', '2021-10-19', '1991-06-18 12:44:47.002067', '2033-04-21 09:36:58.007203', 4.32232974236883e+18, 1.23456789123457e-09) ,  (1, -1011482624, 'zktfdxbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswx', 'ktfdxbz', '2004-12-01', '1991-05-09', '2027-07-06 22:35:18.005323', '2029-03-22 01:49:16.063840', -1.23456789123457e-09, -1.23456789123457e-09) ,  (6, 8, 'tfd', 'fd', '2022-08-19', '2021-09-27', '1980-09-08', '2005-01-28 22:13:14.041476', -5.713500972276e+124, 1.23456789123457e-09) ,  (3, 6, 'foo', 'foo', '2023-06-13', '2034-11-20 22:00:05', '1994-04-25 13:46:28.017576', '1971-09-03', 1.23456789123457e+43, -1.1474609375e+80) ,  (6, -1616904192, 'dxbzjqdogbtoknjbttgxwludawgrcslrhdsl', 'bar', '2021-09-22', '2029-11-22 06:00:41', '1994-11-12 20:55:52', '2015-04-09 07:52:17', 2.1211954244915e+18, 0.123456789123457) ,  (-1688993792, 6, 'foo', 'xbzjqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeup', '1992-08-16', '2035-03-17 02:49:53', '2011-06-13 23:07:35', '2023-06-19', -0.123456789123457, -1.23456789123457e-09) ,  (7, 1721237504, 'foo', 'bar', '1972-01-03 09:48:35', '2004-01-07 01:59:59', '1988-11-20 06:45:00.007347', '2026-11-20 18:07:04.005084', -1.23456789123457e+39, 0.123456789123457) ,  (1, 1, 'bzjqdogbt', 'zjq', '2004-01-18', '2003-01-07 20:49:16', '1977-10-10 09:12:25.012057', '1975-06-25 17:24:51.044833', 1.23456789123457e-09, -1.23456789123457e+39) ,  (9, 3, 'jqdogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtf', 'qdogbt', '2001-06-06 21:19:45', '2006-04-04 01:44:02', '1982-09-07 13:14:29.036657', '2019-02-08', 0.123456789123457, 1.23456789123457e+25) ,  (1969487872, 0, 'foo', 'bar', '1979-02-21 12:26:20', '2004-11-16 17:24:58', '2024-10-09 15:13:14.044667', NULL, -4.43435678309967e+18, 1.23456789123457e+43) ,  (5, 9, 'd', 'bar', '2020-07-23 02:11:43', '2020-12-01', '1977-07-15 02:55:19.045214', '2006-04-28 15:25:06.056609', 1.23456789123457e+25, -1.23456789123457e+25) ,  (1977286656, -1501757440, 'bar', 'bar', '2033-06-20 20:18:24', '1989-04-24', '1988-11-23 20:54:23', '1994-08-15', -1.52728322363202e+18, -7.54352937584558e+17) ,  (1, -1018691584, 'bar', 'foo', '2035-06-28 22:21:11', '2030-10-03 08:45:34', '2031-11-23 19:13:46.006165', '1992-02-07 21:54:11.034696', -1.23456789123457e+30, -6.4001780204469e+18) ,  (3, 5, 'foo', 'ogbtoknjbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqr', '2033-06-14', '1981-11-14', '1977-08-18 00:38:48.005360', '2018-04-12 22:55:59.053374', -1.23456789123457e+30, 1.42707813192303e+17) ,  (1, 1, 'bar', 'gbtoknj', '2017-10-01', '1977-06-12 09:19:25', '2004-02-04 06:09:08.000561', '2029-08-08 19:18:13.039331', 0.123456789123457, -1.23456789123457e-09) ,  (6, 1, 'b', 'foo', '1976-05-05', '2022-08-02', '1991-08-01 00:40:18.053263', NULL, -1.23456789123457e+44, -1.23456789123457e-09) ,  (5, 1, 'toknjbttg', 'foo', '1994-03-18 12:36:48', '1985-11-17 16:14:09', '2016-08-23 16:54:49.027754', '2020-02-18 20:16:04', -1.23456789123457e+30, -1.23456789123457e-09) ,  (5, 8, 'foo', 'bar', '1990-05-01', '1987-01-03', '1981-11-12 16:38:16.014844', '2007-01-11 19:52:30.037050', -0.123456789123457, 8.56866124102579e+18) ,  (139853824, 639893504, 'bar', 'oknjbt', '2035-05-14 11:55:21', '2025-10-10', '2021-08-24 23:53:48.039734', '1977-03-12 13:46:47.024628', -1.23456789123457e+43, 1.23456789123457e+30) ,  (7, -871628800, 'bar', 'knjbttgxwludawgrcslrhdslznferv', '2012-08-11', '2019-07-12', '2019-05-23 00:57:33.030009', '1972-01-25 02:19:00.017910', 0.687667846679688, 0.123456789123457) ,  (3, 1, 'foo', 'bar', '1976-06-26 06:16:51', '2009-06-08', '1993-01-14 14:30:00.039199', '2009-09-13', -1.23456789123457e+39, 0.091094970703125) ,  (1, 8, 'njbttgxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmje', 'j', '1979-08-27', '2015-05-04', '1982-12-17 12:25:59', '2015-03-02', -1.23456789123457e-09, -3.54949950526825e+124) ,  (1, 1, 'bttgxw', 'ttgxwl', '2009-09-13', '2005-11-26', NULL, '2031-10-19 21:57:12', -3.59162070282797e+17, -7.81036765376728e+18) ,  (1518665728, 1103167488, 'tgxwluda', 'gxwludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoim', '2025-06-10 14:06:10', '1985-09-18', '1978-03-05', '1981-11-16', -1.23456789123457e+44, 1.23456789123457e-09) ,  (-1272643584, 5, 'bar', 'bar', '2004-09-03', '2009-01-27', '2019-09-06 14:26:25', '1983-01-24', 1.23456789123457e+25, 1.23456789123457e+43) ,  (1, 1, 'xwludawgrcslrhd', 'bar', '1990-10-18', '2005-07-27', '2010-10-02 18:42:40.004963', '2003-09-13 14:34:05', 0.123456789123457, 1.23456789123457e-09) ,  (1, 2, 'w', 'bar', '1975-09-08 08:56:52', '1990-08-17', '2031-07-09 08:48:45.049410', '2035-09-16 10:57:10', -1.23456789123457e-09, 0.123456789123457) ,  (1, 1, 'ludawgrcslrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbdh', 'udawgrcslr', '2006-02-12', '2017-06-14 13:42:40', '2035-01-18 02:51:47.019146', NULL, 1.23456789123457e+30, 1.23456789123457e+39) ,  (5, -213188608, 'foo', 'foo', '1980-05-27 12:24:00', '2018-03-09', '2017-01-03 04:49:44.049351', '1987-02-04 06:14:32', 1.23456789123457e+39, -8.61206054687501e+79) ,  (5, 18350080, 'dawgrcslrh', 'bar', '2010-12-24', '1995-08-28 17:15:25', '2005-02-02 01:56:11.006146', '1990-07-20 19:11:22.043715', 1.23456789123457e+25, -0.123456789123457) ,  (6, 1, 'awgr', 'wgrcslrh', '2018-12-19 12:19:54', '2001-03-02', '2001-02-24 19:12:04.054979', '1983-06-10 14:07:42.038127', -1.23456789123457e+39, 1.23456789123457e+44) ,  (1471938560, 5, 'gr', 'foo', '1992-06-04 06:09:56', '2025-03-04 21:32:02', '1996-10-02', '1985-05-24 18:04:59.025728', -604962816, -3.21472167290222e+124) ,  (3, 2, 'foo', 'bar', '2023-04-12', '2005-08-21 14:25:00', NULL, '1999-12-17', -7.56027221435715e+124, 1.23456789123457e-09) ,  (-943325184, 1111883776, 'foo', 'rcs', '2030-01-05', '2007-04-20 05:12:34', '1972-01-18 15:35:34', '2034-03-04 12:59:26.024865', 1.23456789123457e+43, 6.74723666673113e+18) ,  (1, 1, 'cslrhds', 'slrhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmml', '2012-01-26 20:56:17', '2016-09-11', '2030-05-13 12:42:47', '1996-02-19 13:36:45.014922', -1.23456789123457e+43, -0.123456789123457) ,  (1587216384, 1, 'lrhds', 'bar', '1971-07-21', '2024-07-15 18:44:58', '2029-04-21 07:28:00.039573', NULL, 0.123456789123457, 0.123456789123457) ,  (-63897600, 1, 'rhdslznferveonhvelrhocfibmshyczovlceatyrbxgeupi', 'hdslznf', '2019-02-01 19:03:14', '2005-12-21 21:28:25', '1974-12-16 03:57:16.040838', '2002-05-16 16:03:51', -1.23456789123457e-09, -0.123456789123457) ,  (2002124800, 2, 'dslznferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjc', 'sl', '2033-11-13 17:08:08', '1982-03-27', NULL, '1971-04-25 11:42:08.005264', -1.23456789123457e+25, 1.23456789123457e-09) ,  (8, 1, 'bar', 'bar', '1973-12-13 19:41:55', '2009-04-06', NULL, '1978-06-09 23:27:53.029048', -1.23456789123457e-09, 1.23456789123457e+39) ,  (7, 1, 'bar', 'lznferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmj', '2004-12-03', '2007-10-18 04:21:05', '1975-09-05 08:25:34.020042', '1978-06-08 19:09:27', -1.23456789123457e+39, -0.123456789123457) ,  (0, 4, 'znferve', 'nferveonhv', '1971-12-19 04:09:15', '1997-08-14 01:07:54', NULL, '1990-01-25', 0.2137451171875, -1.23456789123457e+39) ,  (1, 6, 'bar', 'ferveonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczm', '1977-06-17', '2002-12-12 21:48:32', '1975-09-04 01:46:03.042603', '2017-07-01 19:00:54.042408', -1.23456789123457e+30, -0.123456789123457) ,  (687407104, 9, 'erveon', 'foo', '1976-04-22 10:22:07', '2008-12-26', '2021-03-24', NULL, 0.123456789123457, -1.23456789123457e+44) ,  (1, 5, 'bar', 'rv', '1976-10-06', '1993-11-15', '1996-10-21', '1997-09-12 06:11:08.047125', -0.123456789123457, 7.00619364530494e+18) ,  (1, -537001984, 'veonhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfaf', 'eonhvelrho', '1997-03-08', '2021-02-19 17:42:38', '2021-05-02', '2027-05-10 09:39:01.053601', 1.23456789123457e+39, 1.23456789123457e+39) ,  (-540016640, 9, 'foo', 'foo', '2026-01-26 06:09:10', '2013-02-25', '2024-11-15 15:25:43', NULL, -3.67718909574801e+18, 1.23456789123457e+30) ,  (2, 2, 'onhvelrhoc', 'bar', '2005-10-09', '2029-11-02 08:57:45', '1997-06-02', '2031-05-13', 0.123456789123457, 1.23456789123457e+30) ,  (6, -1064960000, 'foo', 'nhvelrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwc', '2014-05-11 15:32:25', '2018-10-10', '2009-01-04 08:36:41.032835', '2028-04-08', 1.23456789123457e+30, 1.23456789123457e+43) ,  (-293601280, 3, 'bar', 'bar', '2010-10-22', '1987-08-28 06:10:07', '1985-08-05', '1973-10-01 15:56:35.001716', 1.23456789123457e+25, -1.23456789123457e+39) ;
DROP TABLE if exists rqg_table4 cascade;
CREATE TABLE rqg_table4 (
c0 int,
c1 int,
c2 text,
c3 text,
c4 date,
c5 date,
c6 timestamp,
c7 timestamp,
c8 numeric,
c9 numeric)    PARTITION BY hash( c5) distribute by replication;
create TABLE rqg_table4_p0 partition of rqg_table4 for values with(modulus 2,remainder 0);
create TABLE rqg_table4_p1 partition of rqg_table4 for values with(modulus 2,remainder 1);
CREATE INDEX idx_rqg_table4_c1 ON rqg_table4(c1);
CREATE INDEX idx_rqg_table4_c3 ON rqg_table4(c3);
CREATE INDEX idx_rqg_table4_c5 ON rqg_table4(c5);
CREATE INDEX idx_rqg_table4_c7 ON rqg_table4(c7);
CREATE INDEX idx_rqg_table4_c9 ON rqg_table4(c9);
INSERT INTO rqg_table4 VALUES  (9, 1, 'hvelrho', 'velrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjn', '2028-01-16 04:29:41', '2012-05-20 21:31:56', '1982-04-19 01:08:08', '1998-02-06 14:46:41.036100', 9.0863037109375e+80, -1.23456789123457e+30) ,  (1, 1, 'bar', 'foo', '2009-12-04', '1996-07-16', '1998-09-02', '1993-01-19 22:13:59.026447', -1.23456789123457e-09, 0.28497314453125) ,  (-9961472, 1, 'elrhocfibm', 'bar', '1995-02-09 18:40:39', '1977-06-14 09:43:39', '2020-10-25 08:03:15', '1978-07-12', -9.98550415037613e+124, 1.23456789123457e+43) ,  (1, 1, 'lrhocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswx', 'foo', '2004-02-14 19:25:22', '1994-09-01', '2025-04-01 04:40:08', '1993-02-13 22:37:09', 1.23456789123457e-09, 1.23456789123457e+30) ,  (1, 1, 'foo', 'foo', '2016-01-06', '2035-11-10 17:41:42', '2017-01-08', '2025-02-28 01:31:57.054218', 0.950164794921875, -1.23456789123457e+30) ,  (2111897600, 7, 'rho', 'hocfibmshyczovlceatyrbxgeupigmmrxtlwoczmjci', '1981-07-20', '2031-03-03', '2022-06-27 11:44:49.015708', NULL, -1.23456789123457e-09, -1.24749709678163e+18) ,  (1, -687079424, 'ocfibm', 'bar', '2028-03-16 16:11:55', '1974-01-01', '1989-10-19 10:32:42.041735', '1983-09-22', -8.69645088045243e+18, -1.23456789123457e-09) ,  (-901644288, -929169408, 'cfibmsh', 'bar', '1977-07-08', '1984-11-22', '1994-04-25', NULL, 1.23456789123457e+43, 0.123456789123457) ,  (62521344, 1, 'foo', 'foo', '2018-09-11', '1975-07-14', '1997-02-21 12:40:23.058937', '1981-02-16 20:47:44.024680', -1.23456789123457e-09, 1.23456789123457e+25) ,  (9, 7, 'fibmshy', 'ibmshyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxc', '1972-03-04', '1972-09-15 01:13:36', '2029-08-20 04:37:13.059614', '1979-06-14 15:30:27', -1.23456789123457e+39, -1.23456789123457e+43) ,  (3, 5, 'foo', 'foo', '1999-12-24 19:24:33', '2032-08-03 17:07:31', '2035-02-02 05:35:07.024459', '2032-12-02 13:34:50', 0.444625854492188, -1.23456789123457e+39) ,  (1, -183631872, 'bar', 'bar', '1974-09-01 23:29:25', '1975-02-07', '1979-06-02', NULL, 1.23456789123457e+39, -1.23456789123457e+43) ,  (6, 6, 'foo', 'bmshyczovlceatyrbxgeupigmmrxtlwoczmjci', '1977-02-24', '1988-05-23 10:37:05', '2010-10-04 16:26:37.056933', '1994-10-13', 3.31042720109403e+18, 0.123456789123457) ,  (1063190528, 1, 'foo', 'ms', '1991-03-28 13:08:13', '2028-04-23 16:13:21', NULL, '2001-05-06 03:41:08.018651', 1.23456789123457e+39, 1.23456789123457e+39) ,  (0, 1498415104, 'bar', 'foo', '1984-10-27', '1981-08-16', '1989-12-18 09:28:29.032971', '1989-10-10 06:10:28', 1.23456789123457e+30, -1.23456789123457e+43) ,  (-946143232, 2, 'bar', 'foo', '2021-12-14', '2002-11-17 05:06:59', '1999-03-20', '2033-08-19 07:55:44.060658', -2.14371342262836e+18, 2.672119140625e+80) ,  (0, 9, 'bar', 'foo', '1982-06-18 06:13:47', '1973-09-01', '2000-09-24 16:47:55.006566', NULL, 7.68032621452696e+18, -1.23456789123457e+25) ,  (-822738944, 514195456, 'shyczovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvj', 'foo', '2004-01-21 06:43:38', '2021-07-17', NULL, '1994-12-23 06:14:33.062030', 1.23456789123457e+44, -1.23456789123457e+43) ,  (-695533568, 1, 'foo', 'foo', '1977-03-28 17:43:03', '1986-01-06', '2028-01-08 03:12:53.063909', '2034-10-20 03:30:05.015529', 1.23456789123457e+43, -1.23456789123457e-09) ,  (1, 1, 'hyc', 'bar', '2019-12-19 00:19:17', '2010-07-18 09:32:04', '1974-11-16 02:04:26.003126', '1984-04-28 20:06:09.043894', 1.23456789123457e-09, 1.23456789123457e+43) ,  (1, -604241920, 'bar', 'yczovlc', '1986-05-07', '1986-05-25 09:06:18', '1994-09-28 11:39:22.024295', '2025-03-14 05:57:56.064725', 1.23456789123457e-09, -1.23456789123457e+30) ,  (5, 8, 'foo', 'czovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjq', '2024-01-27', '1997-06-01 19:42:14', '1998-11-10 00:24:49.034841', '2017-02-16', -4.75045318194574e+18, -1.23456789123457e+44) ,  (0, 1421344768, 'zovlceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmyw', 'ovlceatyrb', '2029-10-04 18:14:57', '2010-04-08', '1977-05-23 01:40:31', '1985-11-04 05:49:08', -1.23456789123457e+30, -1.23456789123457e+39) ,  (8, 1, 'foo', 'vlc', '1973-04-05 20:56:19', '2023-11-02 09:32:48', '2016-05-03 12:07:44.048730', '2026-12-23 15:18:33.045027', -1.23456789123457e+25, 1.23456789123457e-09) ,  (1767047168, 1338441728, 'bar', 'lc', '1996-09-28', '1993-10-21', NULL, '1993-12-13 11:29:17.011470', -1.23456789123457e+39, -1.23456789123457e+25) ,  (389808128, -1186529280, 'ceatyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtv', 'eaty', '2011-06-07 03:21:36', '2025-03-21', '2035-10-06 06:57:08', '1975-10-27 11:42:32.052082', -1.23456789123457e-09, 0.123456789123457) ,  (2, 9, 'foo', 'atyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdskl', '2004-11-18 09:12:56', '1978-06-28', '1989-01-08 16:34:54.037349', '1975-07-28 10:38:57.030762', -0.123456789123457, 1.23456789123457e+30) ,  (5, 8, 'tyrbxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtf', 'foo', '1981-10-17', '1992-09-14 23:23:32', NULL, '2024-01-01 16:48:33.010060', 1.23456789123457e+25, 0.123456789123457) ,  (1, 2, 'yrbxg', 'r', '1976-09-26 21:09:04', '2011-03-27', NULL, '2022-02-04 12:47:04.001094', -1.23456789123457e+25, -197459968) ,  (35651584, 1, 'foo', 'bxgeupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyze', '2007-02-23', '1995-12-09 01:30:30', '2029-11-25 12:20:42.064208', '1987-01-07 11:04:14', -12058624, -1.23456789123457e-09) ,  (-1633484800, 1, 'bar', 'xgeupi', '1981-09-21', '2035-02-20 22:02:59', NULL, '1991-12-12 14:43:28.062042', -1.23456789123457e-09, -0.123456789123457) ,  (1, 1, 'geupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwoc', 'bar', '1972-06-04', '2012-08-02', '2017-11-23 08:20:02.060538', '1986-11-23 19:50:15.036718', -1.23456789123457e+30, 1.23456789123457e+44) ,  (0, 1, 'bar', 'foo', '2003-08-05', '2000-12-23 03:09:59', '2012-09-06', '1986-04-19 15:11:38', -1.23456789123457e+44, 0.76373291015625) ,  (1, 0, 'eupigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmje', 'bar', '2023-09-26 21:01:52', '2025-07-16 02:29:01', '1987-12-25 05:55:53.037877', '2027-03-20 17:21:27.030272', -1.23456789123457e+44, -0.123456789123457) ,  (2, 7, 'upigmm', 'pigmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsr', '1990-02-04', '2012-10-03 09:15:25', NULL, NULL, -0.123456789123457, 1.23456789123457e+44) ,  (-510787584, 4, 'igmmrxtlw', 'foo', '1999-08-16 01:47:59', '2007-11-18 01:49:14', '1990-12-04', NULL, -1.23456789123457e-09, -1.23456789123457e+43) ,  (3, 1, 'gmmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmlj', 'mmrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoi', '1978-01-05', '1973-12-28', '1973-05-22 01:43:50.026638', NULL, 0.123456789123457, 0.123456789123457) ,  (7, 3, 'mrxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqk', 'rxtlwoczmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoa', '1995-01-12', '1976-05-07', NULL, '2033-05-11 07:46:00.016481', -1.23456789123457e+25, 1.23456789123457e+44) ,  (6, 5, 'x', 'tlwo', '1977-05-21 22:35:03', '1999-11-13', '1973-06-01', '1971-07-18', 1.23456789123457e-09, 1.23456789123457e+43) ,  (1, 9, 'lwo', 'bar', '2023-07-24', '1984-06-07', '2014-12-09 03:33:55.013976', '2035-10-18 00:02:24.015358', 4.9700927734375e+80, 1.23456789123457e+44) ,  (7, 1, 'foo', 'bar', '2012-06-19 17:55:33', '1998-11-07', '1988-02-13 23:21:06.056216', NULL, -0.123456789123457, -1.23456789123457e-09) ,  (1, 1, 'bar', 'foo', '2013-10-13 16:48:49', '2008-12-18 02:04:23', '1971-12-06 01:31:29.050505', '1982-08-17 06:53:18.027648', -1.23456789123457e+25, 1.23456789123457e-09) ,  (-1816920064, 571211776, 'bar', 'foo', '1980-07-26 17:18:43', '1990-10-24 19:01:52', '2014-05-23 18:56:29.014150', '1999-11-28 15:15:42.015544', -1.23456789123457e+25, -6.76055908203125e+80) ,  (1, 1251213312, 'w', 'foo', '2031-06-03', '1980-05-05 16:57:21', '1984-03-26 16:26:34.005188', '1973-05-19 09:30:26', 1.23456789123457e+44, 1.23456789123457e-09) ,  (4, 7, 'ocz', 'foo', '1972-09-25 23:13:31', '1990-11-11 21:30:18', '2000-07-23 05:18:28', '1986-02-09 18:09:52.034268', -1373569024, -0.123456789123457) ,  (-1397620736, 1, 'cz', 'zmjcimusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsd', '2000-04-28', '2013-12-11', '2016-04-17', '1981-05-26 21:09:46.033446', -1.23456789123457e+25, -1.23456789123457e+25) ,  (1, -892469248, 'mjcimusbwc', 'foo', '2021-07-24 08:12:58', '1977-07-11', '1992-06-18 10:21:03.029659', '2035-11-09 03:07:47.000119', 7.87078857421875e+80, -1.23456789123457e+43) ,  (1, 688586752, 'jcimus', 'cimusbwcyh', '2008-12-26 22:03:18', '1997-09-28', '2032-01-24 21:50:50.041740', '1977-04-20', 2.16888427734375e+80, -1.23456789123457e-09) ,  (1, 3, 'imusbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvu', 'bar', '2015-08-06 04:24:57', '1977-03-24 08:24:51', '1981-08-10 09:03:35', '2018-07-27 00:14:30', 1.23456789123457e+39, -1.23456789123457e+43) ,  (6, 1, 'musb', 'foo', '2010-05-12 07:22:57', '2004-03-13', '1996-09-23 21:46:00.065503', NULL, 0.123456789123457, -0.123456789123457) ;
INSERT INTO rqg_table4 VALUES  (1, -615186432, 'usbwcyhbdhnmvblaggzeqgdjuqfjf', 'sbwcyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroys', '2030-01-10', '2011-06-16', '2021-06-05 02:53:08', '1983-11-21 10:39:29.013327', -29163520, 6.27013658120657e+18) ,  (7, 1098645504, 'bw', 'wcyhbdhnmv', '2006-06-09', '2004-06-09', NULL, '1994-12-28 21:03:26.009201', -1.23456789123457e-09, 1.23456789123457e+30) ,  (1, 1, 'foo', 'cyhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwv', '2022-10-11', '1975-12-07 23:14:28', '1991-07-02 08:18:58.006890', '2005-05-15 14:34:21', -1.23456789123457e+30, 1.23456789123457e+44) ,  (1, 1, 'yhbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqt', 'hbdhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdskl', '2010-02-16 15:55:50', '2033-05-27 07:14:11', '2005-10-22', NULL, -1.57501219860626e+124, 1.23456789123457e-09) ,  (3, 6, 'foo', 'bdhn', '2034-01-03', '2004-11-11', '1996-05-06 08:43:39.002447', NULL, -1.23456789123457e+43, -1.23456789123457e+43) ,  (9, 6, 'dhnmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfw', 'hnmvblagg', '1973-04-10', '1981-02-17 19:47:51', '1988-04-16', '1981-11-14 22:25:56', -0.123456789123457, 1.23456789123457e+30) ,  (1, 0, 'nmvblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlq', 'foo', '1976-01-20', '1981-10-02 18:52:30', '1976-01-25 20:28:44.022004', NULL, 0.123456789123457, -1.23456789123457e+39) ,  (1033961472, -1040646144, 'foo', 'mvb', '2033-01-21 07:16:52', '1998-05-16', '2013-05-13 00:11:17.057557', '2029-06-20 16:46:16.029528', 0.123456789123457, 0.123456789123457) ,  (3, 1, 'vblaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzbow', 'foo', '1981-04-16', '1975-12-04 02:11:31', '1993-02-07', '2021-04-24', -4.57962035590775e+124, -1.23456789123457e+30) ,  (1, -729546752, 'blaggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzey', 'bar', '1992-06-26', '1988-04-13 22:49:28', '1997-05-25 15:44:16.031871', '2015-10-19 04:15:41.053809', -1.23456789123457e-09, -1.54708861459396e+124) ,  (-877264896, 1779105792, 'bar', 'laggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroy', '1989-11-06 05:33:56', '2009-09-15 12:58:10', '2014-02-15 22:22:22', '2025-06-01 14:47:06.026726', -1.23456789123457e+44, 310575104) ,  (0, 2135621632, 'foo', 'a', '1989-02-27', '1998-07-11 18:42:02', NULL, NULL, 3.22457733319728e+18, -1.23456789123457e+30) ,  (1, 7, 'foo', 'bar', '2001-09-19', '1997-06-18', '2009-06-08 16:23:27.031864', '2017-04-23 13:57:54.058630', -1.47436592801042e+18, -1.23456789123457e+30) ,  (3, -1096613888, 'ggzeqgdjuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpys', 'gzeqgd', '2015-06-12 04:38:56', '1997-12-13 12:00:21', '2027-09-10', '2000-09-03 19:34:40.032840', -1.23456789123457e-09, -1.23456789123457e+43) ,  (2, 1, 'bar', 'bar', '1995-07-05 08:28:50', '1977-04-01 01:52:34', '2016-11-01 19:39:44.026068', '2031-11-26 23:20:28.038291', -1.23456789123457e+25, -0.123456789123457) ,  (-904396800, 1, 'foo', 'foo', '1994-08-11 01:19:00', '1979-05-03', '1983-10-05 07:25:05.038769', '2021-03-04', 1.23456789123457e+43, -0.123456789123457) ,  (0, -193593344, 'foo', 'foo', '1976-01-24 13:58:33', '1971-09-21 15:54:45', '2016-12-21 00:52:59.056311', '1989-02-03 18:29:40.063538', -3.939208984375e+80, -168165376) ,  (2128216064, 1, 'zeq', 'eqgdjuqfjfgkswxccyvj', '1990-04-04 21:37:17', '1979-02-20 13:26:56', '2023-01-11 08:41:47.059441', '1984-03-04 10:03:49.025901', -4.19341420303535e+18, 0.686660766601562) ,  (9, 1135542272, 'qgdjuqfjfgkswxccyvjqybvqqtfwocyu', 'gdj', '2013-01-03', '2031-08-17 04:07:27', '1974-01-01 08:46:24.012177', '1991-11-13 09:10:50', 1.23456789123457e+30, -1.23456789123457e+44) ,  (8, 5, 'foo', 'djuqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgr', '2029-06-26 04:47:28', '2012-04-02 09:58:15', '1980-01-19 04:33:06.061213', NULL, 0.123456789123457, 1.23456789123457e-09) ,  (7, 5, 'j', 'bar', '2022-05-03', '1983-04-23 08:27:45', '1988-02-07 06:00:53', '2019-09-10 04:51:04.000311', -1.23456789123457e+30, -1.23456789123457e-09) ,  (2, 7, 'uqfjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyz', 'qfjf', '1981-02-23', '2024-03-08', NULL, '1982-10-13 00:46:00.042710', 0.195449829101562, 1.23456789123457e+39) ,  (3, 6, 'fjfgkswxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewj', 'jfgk', '2022-05-01 06:29:09', '2023-08-16', '1988-04-12 09:40:59.037663', '1986-03-07 08:44:00.042080', -0.123456789123457, -1.23456789123457e+43) ,  (-1324679168, -1633943552, 'bar', 'f', '1996-10-11', '2011-08-01', '1972-10-20 16:23:35.045505', '1994-05-16 05:01:39', -1.23456789123457e+25, 1.23456789123457e+25) ,  (7, 116391936, 'gkswxc', 'kswxccy', '1997-06-14', '2030-10-01 10:46:12', '2028-09-25 11:37:21.003702', '1978-09-25 10:39:42.009630', -1.23456789123457e+39, -0.123456789123457) ,  (4, 1, 'bar', 'bar', '2006-06-06', '1999-01-24', '2014-05-22 09:31:58.010747', '2018-06-11 13:28:11.008859', 1.23456789123457e+44, 2143158272) ,  (0, 8, 'foo', 'foo', '1990-03-19 10:03:32', '2012-07-28 09:06:03', '2023-11-26 05:31:11.005168', '2028-06-09 01:16:23.002562', -1.23456789123457e-09, 9.49005126953125e+80) ,  (4, 3, 'swxccyvjqybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygy', 'bar', '1977-11-18 21:30:58', '2010-09-15 01:42:05', '1984-06-04', '2020-01-26 08:55:51', 0.123456789123457, 0.123456789123457) ,  (0, 1, 'bar', 'wxccyvjqybvqqtfwocyuz', '2006-12-13 05:18:33', '2008-12-20', '1974-12-23 01:55:42.002852', '1975-07-18 05:33:22.052513', 1.23456789123457e-09, 0.123456789123457) ,  (1, 104071168, 'bar', 'foo', '2029-03-13', '1993-06-18', NULL, '1984-08-09 09:01:50', 1.23456789123457e-09, 1.23456789123457e+30) ,  (1, 1, 'xccyvjqy', 'ccy', '1994-09-23 14:47:13', '1971-06-14', NULL, '2032-06-17 23:10:58', -1.23456789123457e+25, -0.123456789123457) ,  (1, 1, 'bar', 'cyvjqybvqqtfwocyuzqkrqrmdzh', '1997-09-26 07:08:54', '2022-11-10', '2000-04-22 15:05:28.043614', NULL, 1.23456789123457e+30, -1.23456789123457e-09) ,  (2, 7, 'foo', 'bar', '1973-06-28 05:02:43', '2016-02-04 04:42:39', '2026-03-18 11:05:39.051052', '1977-08-01', -1.23456789123457e+30, 1.23456789123457e+43) ,  (1, 80216064, 'yvjqybvqq', 'foo', '2002-06-04', '1997-10-10 09:47:42', '2009-04-12 07:01:33.040291', '2028-08-07', -6.81701659837952e+124, 4.9843588875923e+18) ,  (3, 4, 'vjq', 'bar', '1986-10-22 04:29:13', '1994-02-13', '1991-10-19 01:39:00.003985', '1985-11-05', 1.23456789123457e+44, -1.23456789123457e+44) ,  (0, 1, 'bar', 'foo', '2031-02-15 20:27:24', '2031-03-17', '2002-09-06 05:29:28.003669', '2035-08-02 01:31:18.032021', 0.123456789123457, -1.23456789123457e+43) ,  (8, 7, 'bar', 'bar', '1997-08-12', '2013-04-01 09:05:03', NULL, '2019-12-04 18:01:07.027101', 1.23456789123457e+30, -1.23456789123457e+39) ,  (1, 6, 'j', 'qybvqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvy', '2014-01-23 18:36:30', '1980-06-22 18:22:22', '1971-10-12 00:38:20.031260', '2021-03-26', -1.23456789123457e-09, -1.23456789123457e+43) ,  (1068695552, -1128398848, 'ybvqqtfwoc', 'bar', '1989-04-03 19:16:35', '2000-01-01', '2011-08-14 17:30:57', '1971-06-13 21:22:38.035314', 1.23456789123457e-09, 0.123456789123457) ,  (-1445396480, -1152647168, 'bar', 'bv', '1974-06-01 11:15:55', '2026-02-09', '2018-11-04 08:19:44.048765', '2017-04-22', 0.260223388671875, 0.123456789123457) ,  (3, 7, 'vqqtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdskls', 'bar', '1992-12-16 15:45:38', '2031-07-07 19:34:25', '1980-09-16 07:51:35.026802', '1978-07-12 09:19:35.053255', 0.123456789123457, 0.333892822265625) ,  (600965120, 3, 'qqtfwocyuzqkrqrmdzhvlqqmj', 'foo', '2029-10-16', '2014-06-06 04:20:53', '1980-11-26 06:51:33.027792', NULL, 1.23456789123457e-09, -1.23456789123457e-09) ,  (1, 58720256, 'qtfwocyuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdh', 'foo', '2007-07-09 00:12:45', '2017-02-27', '2031-06-23 07:03:23.024682', '1993-03-20 13:41:31.040005', 1.23456789123457e-09, -1.23456789123457e-09) ,  (-912261120, 1, 'foo', 'tfwocyuzqk', '2010-03-06', '1991-10-23 09:03:37', '2018-01-23 22:27:30.007210', '2032-01-17 07:16:10.042335', -0.123456789123457, 1.23456789123457e-09) ,  (1, 2, 'fwo', 'wocyuzqk', '2023-10-26 22:52:27', '1978-05-20 10:01:49', '2011-01-08 03:14:29.024386', '2003-03-06 14:13:58.011982', 1.23456789123457e-09, 1.23456789123457e+39) ,  (3, -1189543936, 'bar', 'bar', '1993-05-11', '2018-04-08', '2011-12-17 13:05:07', NULL, 1.23456789123457e+44, -1.23456789123457e-09) ,  (1, 1, 'bar', 'ocy', '2027-09-22 20:12:46', '2012-08-03 03:12:56', '2000-05-21 05:28:24', '1971-10-08 16:39:49', -5.8355712890625e+80, -1.23456789123457e+39) ,  (-2134966272, 1, 'cyuzqk', 'foo', '2010-08-11 21:01:15', '1988-02-27 12:39:13', '1975-12-15', '1990-12-24 05:33:33.051887', 1.23456789123457e-09, 0.420196533203125) ,  (1, -1623523328, 'yuzqkrqrmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspn', 'uzqkrqrm', '2001-10-09', '1986-12-14 15:34:59', NULL, '1981-11-19 07:04:57', 1.23456789123457e-09, 0.613265991210938) ,  (1, 1, 'bar', 'foo', '1971-02-12 22:35:43', '2030-03-08 20:13:17', '2011-10-03 14:06:05.055184', '1994-05-24 05:06:41.051886', 831258624, -8.61755370955506e+124) ;
DROP TABLE if exists rqg_table5 cascade;
CREATE TABLE rqg_table5 (
c0 int,
c1 int,
c2 text,
c3 text,
c4 date,
c5 date,
c6 timestamp,
c7 timestamp,
c8 numeric,
c9 numeric)    PARTITION BY hash( c6) ;
create TABLE rqg_table5_p0 partition of rqg_table5 for values with(modulus 4,remainder 0);
create TABLE rqg_table5_p1 partition of rqg_table5 for values with(modulus 4,remainder 1);
create TABLE rqg_table5_p2 partition of rqg_table5 for values with(modulus 4,remainder 2);
create TABLE rqg_table5_p3 partition of rqg_table5 for values with(modulus 4,remainder 3);
CREATE INDEX idx_rqg_table5_c1 ON rqg_table5(c1);
CREATE INDEX idx_rqg_table5_c3 ON rqg_table5(c3);
CREATE INDEX idx_rqg_table5_c5 ON rqg_table5(c5);
CREATE INDEX idx_rqg_table5_c7 ON rqg_table5(c7);
CREATE INDEX idx_rqg_table5_c9 ON rqg_table5(c9);
INSERT INTO rqg_table5 VALUES  (839843840, 9, 'bar', 'zqkrqrmdzhvlqqm', '1994-05-09', '2005-08-24 13:01:21', NULL, NULL, -0.123456789123457, 0.123456789123457) ,  (1, 2, 'bar', 'qkrqrm', '2030-05-02 20:05:33', '2030-01-15', '2004-10-01 03:26:27.008168', '2031-11-13', -1.23456789123457e+25, 1.23456789123457e+39) ,  (1, 6, 'krqrmdzhvl', 'bar', '2024-01-14 07:53:44', '2006-09-11 07:09:11', '1979-05-15 07:20:48', '1986-11-06 03:08:49.040644', -0.123456789123457, -1471348736) ,  (1, 6, 'bar', 'rq', '1975-04-03', '2013-11-15 17:37:42', '1992-01-03 22:47:51', '1990-09-10 04:03:28.022432', 1.23456789123457e+39, -5.30197143084885e+124) ,  (1120206848, 1, 'qrmdzhvlqqmjeazfaanjvuwnypaighga', 'foo', '1982-11-02 16:15:27', '1984-02-24 15:42:08', '2005-01-22 20:52:33', NULL, -0.123456789123457, -5.19265037035818e+18) ,  (4, 4, 'foo', 'rmdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpy', '1978-05-27 17:35:27', '1978-02-27', '1994-03-28', '1999-03-23', -0.123456789123457, 1.23456789123457e+25) ,  (1, 1, 'mdzhvlqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgro', 'foo', '2020-12-02 00:07:45', '1999-10-11', '1971-01-13 19:43:05.032915', '1975-07-07 03:29:07.000385', -7.45908688283238e+18, -1.23456789123457e+25) ,  (-400490496, 1, 'dzhvlqqmj', 'zhvlqq', '1998-06-23', '1980-06-16', '1981-08-19 16:36:29.020293', '2019-03-20 06:38:57.002099', -1.97032483697459e+16, 1.23456789123457e+39) ,  (1, 1, 'hvlqqmjeazfaanjvuwnypai', 'vlqqmj', '2021-10-06', '1998-09-11 06:37:45', '1978-03-25 15:29:58.012565', '1978-10-10 03:01:40.042021', 2060779520, 1.23456789123457e+39) ,  (7, 3, 'lqqmjeazfaanjvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyik', 'qqmjeaz', '2020-10-25', '1986-12-05 23:51:17', NULL, '1974-10-05 13:18:31.002137', 7.40478515625e+80, -1.23456789123457e-09) ,  (9, -873332736, 'foo', 'qmjeazfa', '1972-12-02', '1990-04-14 18:58:07', '2023-04-13 18:04:18.063622', '1996-06-09 15:36:04.044555', 1.23456789123457e+30, 1.23456789123457e+30) ,  (1, 5, 'mjeazfaanjvuwnypaighgafhwtvbgoaydqm', 'jeazfaanj', '2003-02-02 19:44:32', '2029-11-20', NULL, '2032-02-28 07:27:44.017123', 1.23456789123457e+44, 7.8656005859375e+80) ,  (8, 1, 'e', 'azfaa', '2004-03-28 02:22:02', '1975-04-15', '2024-03-03', '1990-01-13 15:23:11', 1.23456789123457e+25, -1.23456789123457e+44) ,  (-1408237568, 2, 'zfaan', 'faanj', '1984-10-03', '1985-07-13 15:37:04', '2030-12-09 11:07:08.015030', '1977-06-25 16:55:26.035539', 0.423965454101562, 1.23456789123457e-09) ,  (3, 7, 'bar', 'foo', '1997-12-22 19:32:52', '2035-03-09 19:02:22', '2006-08-21 17:25:56', '2033-07-13 17:54:38.065313', 0.512344360351562, -8.69673235542914e+18) ,  (614793216, 1463484416, 'aanjvuwn', 'anjvuwn', '1987-06-16 17:31:12', '1971-06-24 17:21:07', '2008-11-18 15:28:12.063430', '1998-12-02 20:57:37.004524', 0.606781005859375, 1.23456789123457e-09) ,  (1, 4, 'foo', 'foo', '2015-02-24 03:54:11', '1974-05-14 13:34:41', '1992-03-06', '2027-12-08 16:53:47.065019', -1.23456789123457e-09, 358350848) ,  (1, 0, 'njvuwnypaighgafhwtvbgoaydqmmljdsklsrutoimscnwd', 'jvuwnypaighgafhwtvbgoaydqmmljdsklsrutoi', '2014-05-19 22:23:53', '1998-04-12', '1986-04-22 12:09:35.010296', '1972-01-24 20:34:57.024011', -6.46913938974101e+18, -0.123456789123457) ,  (1, 6, 'bar', 'v', '2022-06-04', '2004-12-25 11:42:55', '1980-06-08 03:31:28.008948', '2004-02-05 14:31:08.029960', 1.23456789123457e+39, -1.42341895722579e+18) ,  (8, 2044592128, 'uwnypaig', 'wnypai', '2031-11-24 02:53:45', '1989-06-20', NULL, '1977-10-08 01:26:06.000066', 1.23456789123457e+39, 1.23456789123457e+30) ,  (8, 4, 'nypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzb', 'ypaighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyz', '1999-09-03 03:38:50', '2020-06-14', '2035-08-15', '1991-12-03 13:51:28.022059', 0.123456789123457, 79233024) ,  (-824115200, 4, 'foo', 'bar', '1982-03-09', '1997-08-13', '1974-01-26', '2012-07-03 08:02:40.017240', -0.123456789123457, -1.23456789123457e-09) ,  (1, 0, 'paighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxk', 'aighgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmy', '1986-02-07', '2025-12-07', '2005-09-07 23:01:26.000048', '2011-04-11 20:48:06', -8.96413358330426e+18, 1.23456789123457e-09) ,  (2, 2102657024, 'foo', 'foo', '1991-05-23', '2032-10-21 17:28:46', NULL, '2012-04-25 00:24:12.056918', -9.98703002928391e+124, -6.3934326171875e+80) ,  (7, -1371602944, 'bar', 'foo', '1992-05-23 07:17:58', '1971-02-22 17:09:13', '1991-05-16 16:13:26.047663', '1983-05-19 02:10:37.006072', 1948450816, 0.123456789123457) ,  (2, 4, 'ighgafhw', 'foo', '2034-04-06', '1987-12-09 01:40:04', '2015-05-10 11:45:11.018316', '1998-12-17 06:30:49.012996', -1.23456789123457e+39, -1.23456789123457e+39) ,  (1, 8, 'foo', 'ghgafhwtvb', '1992-05-26', '1995-11-20', '1979-05-03', '1990-04-27', 1.23456789123457e+43, -1.23456789123457e+30) ,  (2, 2, 'hgafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkx', 'foo', '2027-02-12 20:41:37', '1972-11-23', '2032-12-20 07:51:34.061877', '2027-08-05 04:16:26.062150', -1.23456789123457e-09, 1.23456789123457e+30) ,  (-1101463552, 2, 'gafhwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfp', 'bar', '2015-12-05', '1999-03-16', '2029-05-01 03:11:26.019836', '2002-01-26', -1.23456789123457e-09, 0.123456789123457) ,  (9, 2, 'bar', 'afhwtvbgoaydqmmljdsklsrutoimscnwd', '2003-05-24 16:14:40', '1972-07-10 02:03:43', '1997-06-14', '1978-12-03 10:25:45.032744', 1.23456789123457e+25, -1.23456789123457e+25) ,  (5, 7, 'foo', 'bar', '2003-11-17 04:32:18', '2002-11-18 17:33:56', '1995-07-08 20:10:37', '2009-07-19 09:25:29.037926', 1.23456789123457e+39, 1.23456789123457e+30) ,  (1, 960823296, 'fhwtvbgoaydqmm', 'hwtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzb', '2031-03-18', '1997-10-05', '1983-06-12', '1975-08-18 12:33:46.050716', 1.23456789123457e+30, -1.23456789123457e+30) ,  (2, 1787166720, 'wtvbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzbowek', 'tvbgoaydqmmljdskls', '1972-02-20 16:44:50', '2028-06-21', '1990-06-22 05:15:20.016478', '2012-07-26 04:44:13.002256', -1.23456789123457e+44, -3.95922702241209e+18) ,  (1, 9, 'vbgoaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfa', 'bgoaydqmmljdsklsrutoimscnw', '2006-01-22', '1992-05-23', '2004-06-06 18:35:51.026219', '1972-04-02 19:58:46.059994', 1.23456789123457e+30, -1.23456789123457e+43) ,  (1, -385024000, 'goaydqmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgai', 'bar', '2008-04-11 20:58:05', '2003-09-03 20:01:09', NULL, '1988-02-18 04:35:36', -1.23456789123457e-09, -1.23456789123457e+43) ,  (1505951744, 1, 'bar', 'oaydqm', '2018-07-08 08:26:14', '1994-04-28 13:41:30', '2026-02-07 23:57:14.006811', '1986-05-01 18:58:35.051564', 8.34442138671875e+80, -2.26840683731118e+18) ,  (9, -195035136, 'aydqmmljds', 'foo', '2005-06-21 20:45:20', '2024-01-26 06:53:06', '1987-03-16 13:20:54.012981', NULL, -1.23456789123457e+25, -1.23456789123457e+39) ,  (1, 1, 'ydqmmljdsk', 'd', '2020-04-14', '1984-11-24 05:58:42', NULL, '2033-10-23 01:40:08', -0.123456789123457, -6.37259347272925e+18) ,  (5, 1449132032, 'foo', 'qmmljdsklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotx', '2032-06-22 19:51:46', '2000-03-09', '2001-12-20 11:01:14.029960', '2012-03-21', -1.23456789123457e+39, 1.23456789123457e-09) ,  (6, 3, 'mmljdsklsr', 'bar', '1975-11-19', '1971-01-20 12:19:07', '2023-05-06 02:05:25', '1993-04-06 00:41:52.062176', -1.23456789123457e+25, -1.23456789123457e+43) ,  (-1632567296, 1083244544, 'bar', 'mljdskls', '2032-07-23 14:33:16', '1979-10-04', '2033-02-08', '2012-02-19 06:55:45.035249', -1.23456789123457e+25, -1.23456789123457e-09) ,  (7, 5, 'bar', 'bar', '1973-07-10', '2033-01-03', NULL, '1976-07-20 05:50:50.027567', -1.23456789123457e+39, -0.123456789123457) ,  (1, 1, 'foo', 'ljdsklsru', '1995-09-18', '2003-01-17', '1994-03-17 10:25:22', '1993-08-20', 7.72085861117329e+18, -1.23456789123457e+44) ,  (1, 2, 'jdsklsrut', 'foo', '2016-01-08 21:16:27', '1982-07-05', '2035-11-16 00:32:15.004813', '2003-12-12 00:01:03.063067', -1.23456789123457e+39, 1.23456789123457e+30) ,  (1, -874315776, 'bar', 'dsklsrut', '2027-02-18', '2014-10-28', NULL, '2017-10-06 18:08:30.023906', -0.123456789123457, -1.23456789123457e-09) ,  (1, 1944256512, 'foo', 'bar', '2031-09-11 15:16:46', '1984-06-03', '1993-06-02 03:09:21.017864', '1999-04-01 11:43:14.020238', -1.23456789123457e+44, 1.23456789123457e-09) ,  (1890844672, 0, 'bar', 'foo', '1975-12-08 04:38:13', '2013-05-26', '2000-03-25 12:47:57.015228', '2015-11-18 03:28:50.022951', -1.23456789123457e+39, 1.23456789123457e+30) ,  (1, 0, 'foo', 'bar', '1988-12-11 06:41:18', '1987-11-13 17:43:02', '2027-05-02 16:31:00.020497', '1972-04-02 23:23:17', -1.23456789123457e-09, -3.97977469571197e+18) ,  (2, 0, 'bar', 'sklsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpy', '1996-02-05', '1976-12-13 16:56:53', '1980-03-17', '2030-03-05 13:24:37.035734', -6.33331298461456e+124, 0.622970581054688) ,  (1, 9, 'klsrutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyu', 'lsru', '2024-06-23', '2011-05-17 10:44:39', NULL, '2019-11-12 15:13:22.014573', -1.23456789123457e-09, 1.23456789123457e-09) ;
INSERT INTO rqg_table5 VALUES  (6, 1499267072, 'bar', 'srutoi', '1971-10-21', '1976-05-26 13:13:51', '1981-06-22 15:10:19.062234', '1995-10-17 00:26:56', 3.50408198507096e+18, 0.472900390625) ,  (1, 6, 'bar', 'rutoimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgr', '2027-03-24', '1971-01-01 17:05:10', NULL, '1987-02-17 11:49:53.031439', -1.23456789123457e+25, 1.23456789123457e+44) ,  (1, -939524096, 'bar', 'bar', '1992-04-04 01:33:56', '2002-01-14 23:02:01', '2014-03-23 05:48:40.061251', '2022-06-18 08:42:08.028754', -1.23456789123457e+30, -1.23456789123457e+43) ,  (-1125974016, 9, 'utoi', 'toimscnwdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrke', '1988-08-07 09:31:46', '2035-01-04 20:28:07', '1972-08-23 03:20:16.043509', NULL, -1.23456789123457e+39, 1.23456789123457e+39) ,  (1, 3, 'o', 'imscnw', '1991-07-25 03:31:09', '1995-08-22 05:22:19', '2004-11-08 00:10:14.041367', '2008-12-22 18:49:07.023620', -1.23456789123457e+44, 1.23456789123457e+39) ,  (3, 1728643072, 'mscnw', 'scnwd', '2003-06-18 09:20:02', '1991-10-10', '1990-12-01 08:14:34', '2019-07-15 01:22:05.003549', 1.23456789123457e+43, -1.23456789123457e+43) ,  (1, -14286848, 'cnwdroew', 'foo', '2027-10-04 17:55:27', '1992-03-09', '1993-10-24', NULL, 1.23456789123457e-09, -1.23456789123457e+39) ,  (1, 2, 'bar', 'n', '2014-03-15', '2003-08-01', '1972-02-11', '1995-11-05 07:59:27.018010', -0.123456789123457, -1.23456789123457e-09) ,  (0, 1, 'foo', 'bar', '1988-01-24', '2015-07-06', '2031-02-09 04:56:53', '2026-09-25 09:52:45.036935', 1.23456789123457e+30, -1.23456789123457e+39) ,  (1, 75300864, 'wdroewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkx', 'droewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotx', '1989-02-06', '1976-04-06', '2011-04-10 18:41:34', '1998-08-07 22:31:00', -1.23456789123457e+25, -1.23456789123457e-09) ,  (2121334784, 1014104064, 'roewjnlm', 'foo', '2027-10-12 04:58:08', '2017-07-02 06:08:55', NULL, '1987-12-17 16:58:40.022440', 1.23456789123457e-09, -7.54653930418717e+124) ,  (1, 0, 'foo', 'foo', '1997-02-21 03:17:50', '1987-04-14 12:49:43', NULL, '2016-10-03 07:05:38.030525', -1.23456789123457e-09, -6.34613027743988e+123) ,  (4, -1593638912, 'foo', 'oewjnlmyw', '1974-02-28', '1998-01-17 20:08:11', '1974-10-03 22:13:51.035486', '1994-06-25 00:49:43', 1.23456789123457e-09, -1.23456789123457e+25) ,  (1, 4, 'foo', 'bar', '2008-01-18 21:55:17', '1984-10-13', '1989-03-06 03:01:53', '2025-02-23 14:17:49.024434', 0.303909301757812, -1.23456789123457e+25) ,  (2, 1, 'ewjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgai', 'wjnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbh', '1986-05-19', '2005-06-25 06:35:58', NULL, '2011-09-14', -3.63403319675903e+124, -1.23456789123457e-09) ,  (0, 6, 'bar', 'bar', '2003-01-28 13:54:55', '1986-05-22', '2012-09-10', '1984-07-26 16:44:49.011339', 1.23456789123457e+39, 1.23456789123457e-09) ,  (7, 2, 'bar', 'foo', '2011-11-01 22:12:09', '2035-07-21', '1996-10-21 19:03:20.007766', NULL, 0.123456789123457, 1.23456789123457e-09) ,  (7, 1777860608, 'jnlmywxuazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcyk', 'bar', '2033-05-09 23:07:45', '2015-07-28', NULL, '2022-01-28', -7.72552490006928e+124, 367329280) ,  (-533856256, 1, 'bar', 'bar', '2002-07-02', '1972-10-10 23:33:41', '2002-03-25 09:25:06', '1991-01-28', -1.23456789123457e-09, -1.23456789123457e+25) ,  (1693450240, 1, 'bar', 'nl', '2027-11-01', '1972-05-16 12:58:25', NULL, '2002-09-17 11:28:27.029818', -0.123456789123457, -1.23456789123457e+30) ,  (-1879769088, 4, 'bar', 'lmywxuaz', '2034-06-09 10:30:48', '2031-11-10', '1992-01-16 17:58:05.044151', NULL, 7.82894500223019e+18, 1182072832) ,  (1, 4, 'foo', 'foo', '2003-01-11 03:22:10', '1998-07-01 13:04:30', '1986-02-13 01:55:42.018075', NULL, 0.943161010742188, 0.123456789123457) ,  (8, 7, 'bar', 'mywxuaz', '1984-09-08', '1983-03-08', NULL, '2014-02-28 19:52:59.007454', -1.23456789123457e+43, -0.123456789123457) ,  (-1341980672, 1, 'foo', 'bar', '2016-02-25 02:35:12', '1981-09-23', '2016-01-19 21:17:30', '2014-02-10 22:43:29.000674', 1.23456789123457e+30, 1.23456789123457e+44) ,  (5, -1959395328, 'ywxuazsdh', 'wxuazsd', '2031-04-08 10:27:27', '2024-05-15 01:39:21', NULL, '2028-06-19 09:04:07.038917', -1.23456789123457e+25, -1.23456789123457e+43) ,  (8, 1, 'xuazsd', 'uazsdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrx', '2007-09-20 16:32:30', '2004-04-21 08:11:47', '2028-08-06 02:43:56', '1986-08-23 08:52:32', -1.23456789123457e-09, 1.23456789123457e+43) ,  (8, 1888878592, 'bar', 'azsdhc', '1975-02-23 14:48:28', '1998-07-03', NULL, '2012-04-17', 0.123456789123457, -1.23456789123457e+30) ,  (1, -1286864896, 'foo', 'zsd', '2028-11-04', '1974-06-21 19:13:44', '2034-01-06 13:19:49.010752', '2031-07-18 22:06:33.007916', 1.23456789123457e+43, -6.21002197265625e+80) ,  (7, 1, 'bar', 'sdhcqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpy', '2032-10-28', '2030-09-19 17:27:26', '1972-02-05 16:20:46', '2017-08-04 02:40:34.013066', 0.123456789123457, 1.23456789123457e+43) ,  (4, 878968832, 'foo', 'dhc', '2027-09-27 23:30:49', '2004-05-22 14:22:19', '2012-11-08', '1984-06-23 00:17:11', -1.23456789123457e-09, -1.23456789123457e+25) ,  (9, 1160708096, 'bar', 'bar', '2007-01-20', '1981-09-19', '2030-11-14 21:00:29.014701', '2027-01-20 09:42:19.062945', 8.44424930131968e+17, 1.23456789123457e+43) ,  (3, 1, 'bar', 'foo', '2004-11-04', '1982-06-13', '2014-04-14 12:23:10', NULL, 192544768, 0.123456789123457) ,  (1, 7, 'bar', 'hcqxox', '2000-05-07', '2019-12-16', '1971-12-25 09:58:41', '1985-04-25 12:26:13.012070', 1.23456789123457e+25, 1.23456789123457e-09) ,  (0, 4, 'cqxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmp', 'qxoxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwat', '1989-06-26', '2028-01-10 01:39:15', '2015-11-28 07:51:48.059742', NULL, 1.23456789123457e+30, 1.23456789123457e+25) ,  (8, 2, 'xoxrfafv', 'bar', '2029-01-17', '1993-09-08', '1995-11-04 19:18:48.017434', '2020-06-28 07:00:25.014083', 0.123456789123457, 552468480) ,  (1, 4, 'bar', 'bar', '1987-06-13 21:16:01', '1991-05-07 12:59:23', '1985-07-12', '2027-03-04 19:13:34.051368', -1.23456789123457e+25, -0.123456789123457) ,  (8, 1, 'bar', 'bar', '1972-12-17 09:06:47', '1989-10-21', '1971-12-17 14:48:27.037516', '1973-06-25 22:51:56.014629', 1.23456789123457e+25, -9.07981979873234e+18) ,  (2, 6, 'foo', 'oxrfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoao', '1989-10-07 03:58:12', '2002-02-07', '1990-02-18 00:00:51.038413', '2012-11-15 04:50:29', -1.23456789123457e+39, 744620032) ,  (-1537867776, 1539506176, 'xrfafvyzpg', 'foo', '2000-10-05 15:41:09', '2031-02-12', '1973-10-04 19:17:23', '1986-05-04 13:16:12', -0.123456789123457, -1.23456789123457e+39) ,  (1, 6, 'rfafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoe', 'bar', '1999-01-12 18:53:14', '1978-08-23 09:42:09', '2033-09-18 03:18:34.040946', '1971-09-13', 1.23456789123457e+44, 4.81322210175222e+18) ,  (2, 8, 'fafvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsng', 'afvyzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxn', '2006-02-28', '1992-04-19', NULL, NULL, -1.23456789123457e-09, 5.7505337741987e+17) ,  (1, -484245504, 'fvyzpgjy', 'foo', '1987-03-22', '2025-08-12 22:29:50', '1973-04-03 02:38:19.039660', '1983-06-15 04:31:15.027497', 0.123456789123457, 1.23456789123457e+43) ,  (2, 46727168, 'vyzpgj', 'yzpgjygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwv', '1975-09-02 16:13:52', '2001-12-24 04:11:04', '1975-03-04 12:01:49.031843', NULL, 0.123456789123457, -4.5854186957573e+124) ,  (2071658496, 1250820096, 'zpgj', 'foo', '2014-10-17', '2008-02-23 11:45:58', NULL, '2016-03-22', 1.23456789123457e-09, -7.44476318359375e+80) ,  (493158400, 2, 'pgjy', 'bar', '2025-09-11 16:10:56', '2002-11-20 06:36:41', NULL, '1974-09-24', 1.23456789123457e+30, 0.123456789123457) ,  (1, -1892155392, 'gjygyz', 'jygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcyk', '2011-04-16 02:57:12', '2003-12-10', NULL, NULL, 1.23456789123457e-09, 0.999130249023438) ,  (4, 303169536, 'bar', 'bar', '2021-03-02 03:29:01', '1983-03-05 09:16:06', '2028-08-06 13:03:31', '2035-09-05 10:59:44', 0.123456789123457, -0.123456789123457) ,  (708247552, 7, 'foo', 'ygyzeyupuvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgy', '1985-12-17', '1992-02-25', '1990-01-26 17:09:56.057205', '1971-01-17 04:42:15.006840', -0.123456789123457, -1.92169188645294e+124) ,  (8, 9, 'bar', 'bar', '2024-05-21', '2002-01-01 17:33:30', NULL, NULL, 1.23456789123457e-09, -1.23456789123457e+44) ,  (1, 1, 'gyze', 'yzeyupuvgroysjmhdapoqzyjxikkytpy', '2017-06-17 06:02:39', '2011-07-10 12:23:35', NULL, '1982-09-03 15:36:42.059161', 0.123456789123457, -1.23456789123457e+39) ;
DROP TABLE if exists rqg_table6 cascade;
CREATE TABLE rqg_table6 (
c0 int,
c1 int,
c2 text,
c3 text,
c4 date,
c5 date,
c6 timestamp,
c7 timestamp,
c8 numeric,
c9 numeric)    PARTITION BY hash( c2) distribute by replication;
create TABLE rqg_table6_p0 partition of rqg_table6 for values with(modulus 4,remainder 0);
create TABLE rqg_table6_p1 partition of rqg_table6 for values with(modulus 4,remainder 1);
create TABLE rqg_table6_p2 partition of rqg_table6 for values with(modulus 4,remainder 2);
create TABLE rqg_table6_p3 partition of rqg_table6 for values with(modulus 4,remainder 3);
CREATE INDEX idx_rqg_table6_c1 ON rqg_table6(c1);
CREATE INDEX idx_rqg_table6_c3 ON rqg_table6(c3);
CREATE INDEX idx_rqg_table6_c5 ON rqg_table6(c5);
CREATE INDEX idx_rqg_table6_c7 ON rqg_table6(c7);
CREATE INDEX idx_rqg_table6_c9 ON rqg_table6(c9);
INSERT INTO rqg_table6 VALUES  (1841430528, -1797324800, 'foo', 'zeyup', '2008-01-04', '1990-10-16', '1978-04-03 09:02:23.050119', '1990-06-15 19:55:40.009328', -1.23456789123457e+39, -1.23456789123457e-09) ,  (7, 0, 'e', 'yupuvgr', '2000-01-18 22:07:15', '1997-03-15', '2021-12-10 07:51:49.031794', '1996-06-19 18:13:01', -1.23456789123457e+39, -1.23456789123457e+44) ,  (5, 0, 'bar', 'upu', '2027-12-22', '2030-06-03', '2006-12-06 18:05:48.028736', '1987-10-15 23:50:47.057273', -6.73372586784902e+18, -1.23456789123457e+43) ,  (-139657216, 4, 'bar', 'puvgroysjmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxy', '2035-05-07', '1999-11-04 22:03:38', NULL, '2009-10-01 06:21:52.064474', -1.23456789123457e+39, -0.123456789123457) ,  (1, 2, 'bar', 'bar', '2020-07-02 01:24:10', '2016-06-11', '1991-11-28', '2004-03-17 05:56:29.002533', 1.23456789123457e+30, 1.23456789123457e+39) ,  (1, 5, 'uvgroysjm', 'bar', '2018-12-07', '2019-07-12 01:25:05', '2010-11-03 02:59:08', '2015-03-27 02:04:07.052723', -4.06585692765961e+124, 0.123456789123457) ,  (1, 1, 'foo', 'bar', '2016-07-07 03:34:42', '2025-09-04 19:39:14', '2007-12-08 11:47:30.011557', '2015-02-23 18:12:42.055045', -1.23456789123457e+44, -1.23456789123457e+25) ,  (1, 3, 'bar', 'vgroysj', '2021-04-12', '1980-09-04', '2006-08-23 14:23:10.056107', '2021-01-22 10:07:40', 1.23456789123457e-09, -1.23456789123457e-09) ,  (2098593792, 1132658688, 'groysjmhda', 'roysjm', '1991-07-13', '1992-04-01', NULL, '1988-08-25 14:18:48.039881', 1.23456789123457e+43, -1.23456789123457e-09) ,  (1, 5, 'bar', 'oysjmh', '1988-04-02 01:03:46', '1994-11-12 15:48:31', '1983-06-26 20:08:14.021442', '2019-01-28', -1.23456789123457e+43, 1.23456789123457e-09) ,  (2, 1, 'ysj', 's', '1985-08-09', '1990-08-25', '1993-05-25 04:54:27.062175', '2016-09-11', 6.83280505965117e+18, 1.23456789123457e-09) ,  (5, 5, 'bar', 'foo', '2008-03-03 19:52:12', '2011-06-02', '1971-02-18', NULL, -1.23456789123457e+30, -0.123456789123457) ,  (5, -878247936, 'foo', 'jmhdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmp', '2006-04-03 06:24:25', '1989-04-23 16:15:22', '1975-04-08 21:09:07.009977', '2006-07-07', 0.123456789123457, 1.23456789123457e+30) ,  (1, 6, 'bar', 'foo', '2028-09-05', '2009-09-20 02:06:17', '1993-02-11 00:40:25.053619', '2007-04-24 15:37:25.040982', 1.23456789123457e+44, 0.32708740234375) ,  (2, 6, 'foo', 'bar', '1994-03-07', '1975-02-13 15:17:56', NULL, '2017-01-08', -1.23456789123457e+25, 0.08941650390625) ,  (2, 9, 'mhd', 'bar', '1984-03-18', '2017-12-05', '1984-11-04', NULL, 0.123456789123457, -1.23456789123457e+43) ,  (1, 3, 'hdapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoiffmnnseegdvu', 'dapoqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesb', '2024-01-03 23:08:49', '2026-05-27', '1980-11-13 17:05:29.044262', '2006-11-17 15:46:56', 1.23456789123457e+30, 3.59978347715258e+18) ,  (757137408, 1, 'foo', 'apoqzyjxi', '1998-11-23 12:52:23', '2007-02-17', '2001-04-04', '1999-09-27 23:45:08', 0.366226196289062, 1.23456789123457e+39) ,  (1, 1, 'bar', 'poqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnua', '2021-01-15 21:57:19', '2016-09-25', NULL, '2015-10-09 11:48:34', -1.23456789123457e+25, 0.123456789123457) ,  (2, 1, 'foo', 'oqzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwf', '1973-01-02', '2006-05-27', '1999-02-09 03:02:55', '2008-11-10 20:42:06.053862', -8.8958740234375e+79, 0.250335693359375) ,  (7, 1711144960, 'foo', 'bar', '1988-11-15 08:50:28', '1993-08-27 00:29:55', '1979-09-01 04:17:51.053574', '2034-04-10 03:08:48', -8.53851318359375e+80, 7.62262384430128e+18) ,  (5, 5, 'qzyjxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoiffmnnseegdvu', 'zyjxikkytp', '2028-01-18 05:52:34', '1977-09-05 01:27:17', '2003-12-20 12:08:36.016386', NULL, -7.10678100296616e+124, 0.123456789123457) ,  (1359085568, 9, 'y', 'jxikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwr', '1989-02-21 19:16:42', '2004-08-18 03:24:27', '1998-07-24 18:38:35', '2005-04-22 01:24:30.024689', 1303052288, -1.23456789123457e-09) ,  (8, 1, 'bar', 'bar', '1975-10-06', '2023-07-20', '2020-12-15', '1996-07-19 08:22:37.043702', 0.123456789123457, -1.23456789123457e-09) ,  (1, 9, 'foo', 'foo', '1978-04-12', '1996-01-15 14:11:56', '2033-01-05 00:44:58.016105', '1990-01-24', -1.23456789123457e-09, -1.23456789123457e+30) ,  (1, 1, 'xikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmp', 'ikkytpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichw', '2016-05-15 22:40:14', '1993-08-28 19:47:55', NULL, '2002-04-04 14:25:54.022145', -4.96240383940887e+18, -1.23456789123457e+39) ,  (8, 1134428160, 'bar', 'kk', '1981-01-07 11:36:21', '2035-09-07', NULL, '1973-06-28 10:31:18.048183', 1.6473388671875e+80, 0.123456789123457) ,  (2, 3, 'ky', 'ytp', '1997-10-03 20:05:06', '2018-01-04', '1998-04-25 15:14:44.014180', '1980-12-16 07:21:22.018776', 1.23456789123457e-09, -1.23456789123457e+39) ,  (5, 8, 'bar', 'foo', '2002-10-06', '1995-11-01', '1973-09-10 19:02:58.060164', '1981-04-18 00:43:01.007878', 1.23456789123457e+39, -1.23456789123457e+39) ,  (4, 0, 'bar', 'tpyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoiffmnnseegdvuqz', '1971-11-05', '1987-04-13 12:23:01', '2027-01-19 10:38:04.041193', '2011-04-15 01:18:08.023954', 0.123456789123457, -8.17749023255249e+124) ,  (0, -231866368, 'foo', 'bar', '1986-10-05 21:25:16', '1990-01-01', '1991-08-09 14:36:19.020665', '2002-12-12 13:38:05.055637', -1.23456789123457e+44, 1.23456789123457e+39) ,  (8, 3, 'foo', 'pyslarksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtq', '2019-08-17 07:40:18', '1994-05-24 02:11:03', NULL, '1993-07-04', -1.23456789123457e+30, 1.23456789123457e-09) ,  (0, 3, 'yslarks', 'slarksxw', '2026-01-24 17:00:03', '2011-02-22 08:44:42', '1991-10-14 13:25:01.033117', '1971-08-16 22:56:53.020302', -0.123456789123457, -7.06783666520457e+18) ,  (1745092608, 1, 'bar', 'bar', '2018-07-13 01:18:51', '2033-07-23', '1979-04-21', NULL, 3.27862052872572e+18, -1.23456789123457e+25) ,  (3, 5, 'l', 'arksxwpyl', '1980-11-01', '2009-05-01 19:49:05', '2021-07-07 07:47:16.040205', '2004-10-15 02:37:44.048816', 9.8321533203125e+80, -6.96932042335584e+17) ,  (917766144, 1, 'bar', 'rksx', '1988-12-13 00:15:08', '2019-11-05 21:19:18', '2021-08-16 02:45:57.023940', '2008-11-05 18:53:57', -1.23456789123457e-09, 3.73939506560106e+18) ,  (2, 1, 'foo', 'bar', '1995-02-26 04:49:24', '1998-02-08', '1977-02-25 08:27:42.017901', '1977-05-02 08:04:18.032733', 0.933609008789062, 0.123456789123457) ,  (2, 1, 'bar', 'ksxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoiffmnnseegdvuqzrsebteg', '2002-10-17', '2006-06-06 18:03:55', '1991-01-20 08:47:47', '2011-05-25 23:39:47', -1.23456789123457e+44, -1.23456789123457e+30) ,  (2, 1, 'sxwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbh', 'xwpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspne', '2031-09-01', '1973-01-12', NULL, '2025-09-01 20:58:04', 0.123456789123457, -1.23456789123457e+25) ,  (-689176576, -1617362944, 'wpylsngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoiffmnnseegdvuqzrsebtegzdud', 'foo', '1979-08-21', '1988-02-28 22:43:20', '1989-03-05 23:32:41.065137', '2029-08-01 06:47:18', 4.19679190275588e+18, -1.0772705078125e+80) ,  (1312882688, 1, 'foo', 'py', '2008-01-14', '1997-11-28', NULL, NULL, 3.16096398846067e+17, -1.23456789123457e+30) ,  (830341120, 1323433984, 'foo', 'bar', '2025-08-28 16:56:23', '2003-08-09', NULL, '1988-07-06', -1.23456789123457e+25, 0.123456789123457) ,  (9, 2138374144, 'ylsngj', 'bar', '2002-09-02 06:00:42', '2019-02-13', '2027-05-21', '1997-07-14', -1.23456789123457e+39, -1.23456789123457e+30) ,  (1, 5, 'bar', 'foo', '1982-02-02 01:59:52', '1991-12-21', '2014-08-02 18:54:03.049439', '1977-11-01', 1.23456789123457e+43, -1.23456789123457e-09) ,  (1, 9, 'lsngjwv', 'sngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesb', '1988-12-19 00:40:32', '2023-04-10 14:02:01', '2003-02-19 21:01:58', '2014-06-21 15:00:45', -1.23456789123457e+44, 0.123456789123457) ,  (6, 1, 'foo', 'foo', '1989-03-03', '1984-02-04 09:34:41', NULL, '1992-08-13 14:03:40.024441', 0.123456789123457, -0.123456789123457) ,  (6, 1, 'ngjwvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuich', 'foo', '2003-03-01', '2033-03-15 17:45:11', '2019-10-15 12:31:23.060022', '2031-04-11 16:36:49.044340', -0.123456789123457, 1.23456789123457e+25) ,  (6, 8, 'foo', 'g', '2024-09-27', '1991-12-22', '1976-02-27', '2027-08-15 15:06:59', 0.123456789123457, 1.23456789123457e+25) ,  (4, 1, 'jwvhnfpxzb', 'foo', '1996-03-02 19:23:29', '1983-03-26', '2018-12-23 13:27:48.064572', '2025-07-11 12:40:23', 460718080, 741081088) ,  (577437696, 9, 'bar', 'foo', '2000-04-23', '2027-08-14', NULL, '1996-10-24 13:26:13', -1.23456789123457e+44, 1.23456789123457e-09) ;
INSERT INTO rqg_table6 VALUES  (2, 4, 'foo', 'foo', '2004-03-26 05:44:53', '2022-05-13 22:42:14', '1982-06-22', '1992-01-20 11:49:15.000057', -1.23456789123457e-09, -1.23456789123457e+44) ,  (7, 1, 'foo', 'wvhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuich', '1985-09-03 05:46:29', '1976-01-18', NULL, '2011-11-16 03:35:44.043061', -1.36123656362686e+124, -7.77008056417633e+124) ,  (7, -1553399808, 'bar', 'vhnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhoch', '1996-03-25 15:55:36', '1984-01-26', '2019-11-17 11:30:26.047696', NULL, -2.95464283053176e+18, -0.123456789123457) ,  (9, 3, 'foo', 'hnfpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoif', '1983-09-17', '1987-04-03', NULL, '1972-08-11', -7.85263061308701e+124, -5.33477783203125e+80) ,  (0, -1025572864, 'nfpxzboweklcykxkxyrxvfgyyikdcykspnebrke', 'fpxzboweklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoiffmn', '1982-03-12', '2022-09-06', '1981-03-25 17:08:40', '2026-05-19', -1.23456789123457e+25, -1.23456789123457e+43) ,  (1, 3, 'foo', 'bar', '2018-10-21 03:16:47', '2003-08-27 10:15:13', '2013-07-03 00:54:38.022333', '1989-03-10 05:41:50.056299', 1.23456789123457e+44, -1.23456789123457e-09) ,  (625278976, 4, 'bar', 'pxzbowek', '1975-04-28', '1999-02-28 16:19:50', '2034-06-05 22:03:39.032139', NULL, -1.23456789123457e+43, -1.23456789123457e+30) ,  (1, -482344960, 'bar', 'foo', '2013-09-13', '2020-12-06', NULL, '1972-03-02 16:30:10.026621', -1.23456789123457e-09, -1.23456789123457e+44) ,  (1, 1, 'xzboweklcy', 'zboweklcykxkxyrxvfgyyikdcy', '1988-03-05', '2009-03-14 11:20:21', '2021-01-21 03:48:11.050375', '2013-01-12 01:40:49.037517', -1.23456789123457e-09, 1.23456789123457e+44) ,  (8, 2, 'bow', 'bar', '2021-01-07', '1997-09-08', '2002-08-03 00:36:09.024600', '1974-01-07 18:33:21.004663', -8.71551513671875e+80, -8.94808950963175e+17) ,  (430178304, 1, 'bar', 'owekl', '1976-01-13 03:22:41', '2015-04-12 00:15:54', NULL, '1997-09-24 08:07:22.024709', 1.23456789123457e+30, 9.63287353515625e+80) ,  (4, 2, 'foo', 'weklcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoiffmnnseegdvuqzrsebtegzdudlzlhlntkn', '2018-06-14 18:15:33', '1977-11-11 06:58:06', '1997-09-04 14:07:44.055056', '2006-05-20 08:20:14', -5.68786620662537e+124, -8.86688232421875e+80) ,  (1, 3, 'eklcykxkxy', 'klcy', '1986-11-13', '2002-07-06', '1999-12-03 09:01:54.036749', NULL, -0.123456789123457, 1.23456789123457e+43) ,  (2, 1, 'lcykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpw', 'bar', '1975-09-27', '1999-03-05', NULL, '1980-07-20 18:44:25.037605', -2.17861631974048e+17, -0.123456789123457) ,  (7, 0, 'cykxkxyr', 'ykxkxyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpw', '1971-03-27', '1985-10-19', '2035-07-02 11:05:48.039806', '2010-03-12', -1.23456789123457e-09, -0.123456789123457) ,  (4, 4, 'bar', 'kxkx', '2023-07-28', '2001-03-04 22:36:33', NULL, '2026-04-13', -1.23456789123457e+30, 1.23456789123457e+39) ,  (-769064960, 1, 'x', 'bar', '1988-04-07 16:13:21', '2012-03-26 07:59:38', '2026-07-21', '1993-09-16 22:59:29.012395', -1.23456789123457e+30, 0.123456789123457) ,  (7, 7, 'foo', 'foo', '2006-04-15', '2015-07-14 08:08:16', NULL, '2023-09-14 02:02:54.010888', 1.23456789123457e+39, 0.665695190429688) ,  (1, 1604386816, 'foo', 'bar', '2019-10-02', '1973-02-14', '1994-10-04', NULL, -1.23456789123457e+30, 0.337753295898438) ,  (8, 4, 'k', 'xyrxvfgyyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzm', '1983-11-19 08:30:51', '1971-01-18 11:01:09', NULL, '1982-03-23 21:40:34.062784', -1.23456789123457e+43, 0.476303100585938) ,  (1, 1, 'foo', 'bar', '2001-07-15 13:08:59', '1978-05-22 02:23:55', '2000-09-04 07:29:11.020309', '2018-09-05 19:13:31.046629', -1.23456789123457e+30, 1.23456789123457e+39) ,  (-1351352320, 4, 'foo', 'yrxvfgyy', '1995-04-11', '1979-09-14 14:30:06', '2014-11-24 21:17:37.005025', '2001-05-13 20:21:04.030618', 1.23456789123457e+25, -6.33769057561713e+18) ,  (0, 1, 'rxvfgyyikd', 'xvfgyyikdc', '2031-10-12 06:01:10', '1980-09-26', '2017-07-09 14:25:25.042876', '1975-01-08 06:42:19', -0.123456789123457, -0.123456789123457) ,  (2046754816, 5, 'foo', 'foo', '2004-01-26', '1974-07-06', '2026-08-24 09:19:44.006988', NULL, 1.23456789123457e-09, 1338441728) ,  (0, 1927872512, 'bar', 'vf', '1986-04-14 17:17:55', '2007-02-07', '2013-12-10 11:50:23.012936', NULL, -1.23456789123457e+30, -350355456) ,  (2054029312, 0, 'fgyyik', 'bar', '1981-03-18 00:50:30', '1995-02-18 17:56:05', '2008-05-16 23:34:40.052090', '2013-01-20 05:56:16', -1.23456789123457e+43, 1.23456789123457e+44) ,  (4, 1, 'gyyikdcyk', 'yyikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoiffmnnseegdvuqzrsebtegzdudlzlhlntkny', '2008-11-02 13:26:00', '1988-01-09 02:12:45', '2021-05-18', NULL, -0.123456789123457, 1.23456789123457e+25) ,  (7, 1, 'yikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoiffmnnseegdvuqzrsebtegzdudlz', 'bar', '2010-10-24 23:14:15', '2030-06-02 17:19:39', '2033-05-22 05:01:06.062208', '2019-07-13 19:19:57.021317', 1.23456789123457e-09, 1.23456789123457e+25) ,  (1, 9, 'ikdcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoiffmnnseegdvuqzrsebtegz', 'kdcy', '1984-12-20', '1982-08-11', '1996-03-23 19:40:55.031527', NULL, 0.123456789123457, 1397227520) ,  (-918618112, 498270208, 'dcykspnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoiffmnnseegdvuqzrsebtegzdudlzlhlntknyygeogqkhqzpsbjkhziglyhznfjfnkdvjwbnbzgqhfiwrdeweamttah', 'bar', '1994-01-02', '2006-11-21', '1980-09-12', '1991-04-02 08:31:54', -0.123456789123457, 1.23456789123457e-09) ,  (1, 0, 'bar', 'cykspneb', '2015-07-26', '2027-10-25', '2033-09-25 17:56:42.030689', NULL, 1.23456789123457e+43, -2.9144287109375e+79) ,  (-1984233472, -1855324160, 'bar', 'y', '2018-09-04', '1987-12-05', '2002-01-18', '1974-09-24 08:26:02.019776', 1.23456789123457e+25, -3.97979735726105e+124) ,  (1, 1116078080, 'kspnebrk', 'foo', '2010-03-28 07:19:12', '2022-09-28', '1985-10-25', NULL, 0.028076171875, -1.23456789123457e+25) ,  (6, 3, 'foo', 'spnebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoiffmnnseegdvuqzrsebtegzdudlzlhlntknyygeogqkhqzpsbjkhz', '2002-06-14', '2029-06-20', NULL, '1981-02-20', 1.23456789123457e+25, -1.23456789123457e+43) ,  (1, -763953152, 'pnebrkeae', 'nebrk', '1996-04-10', '1976-03-25', '2017-12-04 21:54:50.041208', NULL, -6.309814453125e+80, 1.23456789123457e+39) ,  (548339712, 1, 'ebrkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoiffmnns', 'foo', '2000-10-23 00:56:56', '1975-05-02', '1983-09-12 08:37:02', '2008-10-09 08:53:22', 1.23456789123457e+25, -1.23456789123457e-09) ,  (7, 1, 'bar', 'brkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoiffmnnseegdvuqzrsebtegzdudlzlhlntknyygeogqkhqzpsbjkhziglyhz', '1987-06-26 03:29:36', '2017-01-16 04:59:09', '2011-03-17 02:37:08.065267', NULL, -0.123456789123457, -1.23456789123457e+39) ,  (1, 3, 'rkeaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoiffmnnseegdvuqzrsebtegzdudlzlhlntknyygeogqkhqzpsbjkhziglyhz', 'keaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoiffmnnseegdvuqzrsebtegzdudlzlhlntknyygeogqkhqzpsbjkhziglyhznfjfn', '2017-07-19', '1990-07-02', '2034-08-17 14:06:31', '2009-03-11 18:11:10.031107', 0.10992431640625, 1.23456789123457e+30) ,  (1, -1193672704, 'eaeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpw', 'aeoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoiffmnnseegdvuqzrsebtegzdudlzlhlntknyygeogqkhqzpsbjkhziglyhznfjfnkdvjwbnbzgqhfiwrdeweamttahdqld', '2032-09-07', '1998-03-13', '1987-03-08 22:35:19.033723', '2014-05-01 05:05:02', -1.23456789123457e+25, 1.23456789123457e+30) ,  (5, 1, 'eoeotxnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoiffmnnseegdvuqzrsebtegzdudlzlhlntknyygeogqkhqzpsbjkhziglyhznfjfnkdvjwbnbzgqhfiwrdeweamttahdql', 'oeotx', '2031-09-04 22:01:04', '2022-08-28 01:54:02', '2003-02-22 00:22:11.015014', '2031-11-26', 1.23456789123457e+43, -3.9147539760918e+18) ,  (5, 1, 'eotxn', 'otxnu', '2014-06-17', '2031-03-08 11:39:14', '2035-12-26 04:34:02.038975', '2034-03-17 15:47:03.049572', -1.23456789123457e+30, 1.23456789123457e+25) ,  (3, 1, 'txn', 'xnuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoiffmnnseegdvuqzrsebtegzdudlzlhlntknyygeogqkhqzpsbjkhziglyhznfj', '1992-11-15', '2008-03-21', '1984-01-11 02:34:32', '1996-08-15 00:08:19.023107', -1.23456789123457e+43, -4.09349058630307e+18) ,  (1, 1, 'foo', 'nuakbkmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoa', '1986-09-25 02:12:33', '2027-05-21', '2025-04-05', NULL, 1.23456789123457e+39, 1.23456789123457e+25) ,  (708575232, 3, 'uakbkm', 'bar', '1987-07-25 01:26:59', '1994-01-05', '2017-04-23', NULL, -1.23456789123457e+44, -0.123456789123457) ,  (1, 1, 'bar', 'akbkmpxzes', '2016-10-02 21:50:45', '2018-02-10', '2032-02-26', '1974-11-23 06:46:54.022627', 1.23456789123457e+25, -1.23456789123457e+43) ,  (1, 7, 'k', 'foo', '2026-08-03 22:41:04', '1973-08-22 09:28:55', '1989-03-24', '2004-02-03', -4.2762756290419e+124, -0.123456789123457) ,  (912130048, 2, 'bkmpxzesbt', 'bar', '2008-03-22 07:17:55', '2029-08-08', NULL, NULL, 4.37130638831649e+17, 0.123456789123457) ,  (9, 1, 'kmpxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtrgtqoaobgngoiffmnnseegdvuqzrsebtegzdudlzlhlntknyy', 'bar', '2024-02-01', '2020-03-02', '1979-05-18 22:48:25.036091', '2023-07-11 00:55:39.040879', 1.23456789123457e+43, -1.23456789123457e-09) ,  (-1875312640, 1, 'bar', 'mp', '1977-01-23 10:36:08', '2005-06-19', NULL, '2009-06-08 04:25:25.032563', -1021509632, 1.23456789123457e+44) ,  (8, -496631808, 'bar', 'pxzesbtnbhochgaixzlgxxyuuichwrbhppunzmwfvpwathtr', '1987-11-24', '2035-12-15', '2013-10-21', '2018-07-26', 1.23456789123457e+25, 9.06349425008312e+18) ;
analyze;
SET search_path TO chqin,public;


create temp table tmp1 distribute by replication as select * from rqg_table1;

create temp table tmp2 distribute by replication as select * from rqg_table2;

begin;

 CREATE OR REPLACE PROCEDURE bfunc20240606( inout v1 int, inout v2 text, inout v3 date, inout v4 timestamp,inout v5 numeric ) LANGUAGE PLPGSQL AS $$ DECLARE var1 int;
 var2 text;
 var3 date;
 var4 timestamp ;
var5 numeric;
c0type rqg_table1.c0%TYPE;
c2type rqg_table1.c2%TYPE ;
 BEGIN begin begin select c6 into var4 from ( SELECT a1.c0, a1.c1, a1.c3, a1.c2, a1.c4, a1.c5, a1.c6, a1.c7, a1.c8, a1.c9 FROM rqg_table4 a1 WHERE a1.c1 BETWEEN 6 AND 6 + 10 ) t1 where v2 < ( SELECT MIN( c3 ) FROM ( SELECT DISTINCT a1.c0, a1.c1, a1.c3, a1.c2, a1.c4, a1.c5, a1.c6, a1.c7, a1.c8, a1.c9 FROM rqg_table3 a1 WHERE a1.c9 NOT IN ( v5, v5 ) AND ( var4 NOT BETWEEN '2028-03-09 00:36:50.057488' AND TO_timestamp( '2028-03-09 00:36:50.057488','YYYY-MM-DD HH24:MI:SS.US') + interval '1' day ) AND ( v4 < a1.c6 ) ) mm ) AND var1 = 9 order by 1 limit 1;
 end;
 end;
 EXCEPTION WHEN OTHERS THEN begin begin begin set temp_file_limit='10';
 end;
 end;
 exception when others then begin set enable_mergejoin to on;
 exception when others then begin select c4 into var3 from ( SELECT a1.c0, a1.c1, a1.c3, a1.c2, a1.c4, a1.c5, a1.c6, a1.c7, a1.c8, a1.c9 FROM ( SELECT a1.c0, a2.c1, a1.c3, a1.c2, a1.c4, a1.c5, a2.c6, a2.c7, a1.c8, a2.c9 FROM rqg_table3 a1 INNER JOIN rqg_table6 a2 ON ( a1.c1 = a2.c1 AND ( a1.c0 = a2.c0 ) ) WHERE ( NOT ( c0type = 4 ) AND a1.c8 IN ( -0.00000000123456789123456789123456789123456789123456789, 1234567891234567891234567890000000000000,12345678912345678912345678912345678912345678 ) ) OR ( a1.c1 = 0 ) AND a2.c3 IS NULL ) a1 WHERE NOT ( var1 != a1.c0 ) AND c2type IN ( 'oqdynbzzu','qdynbzzuqfdtbrfn' ) ) t1 where c0type = 7 AND ( NOT ( v1 IN ( v1, var1 ) ) AND NOT EXISTS ( SELECT c1 FROM ( SELECT DISTINCT a1.c0, a1.c1, a1.c3, a1.c2, a1.c4, a1.c5, a1.c6, a1.c7, a1.c8, a1.c9 FROM rqg_table6 a1 WHERE v1 = a1.c1 AND ( a1.c5 IS NULL ) AND ( v1 BETWEEN 6 AND 6 + 10 ) ) mm ) ) AND ( var4 NOT BETWEEN '2028-03-09 00:36:50.057488' AND TO_timestamp( '2028-03-09 00:36:50.057488','YYYY-MM-DD HH24:MI:SS.US') + interval '1' day ) order by 1 limit 1;
 select c6 into var4 from ( SELECT a1.c0, a1.c1, a1.c3, a1.c2, a1.c4, a1.c5, a1.c6, a1.c7, a1.c8, a1.c9 FROM ( SELECT a1.c0, a1.c1, a1.c3, a1.c2, a1.c4, a1.c5, a1.c6, a1.c7, a1.c8, a1.c9 FROM tmp1 a1 WHERE var1 = var1 ) a1 WHERE var1 BETWEEN 6 AND 6 + 10 AND ( ( NOT ( var1 NOT IN ( 4, 5, 8, 1, 9 ) ) AND a1.c0 = v1 ) OR ( a1.c1 = 1 ) AND var3 NOT BETWEEN '1981-06-20 04:10:36' AND TO_DATE( '1981-06-20 04:10:36','YYYY-MM-DD HH24:MI:SS') + interval '1' day ) AND ( c0type = a1.c1 ) ) t1 where var5 != -2.82089232680527e+124 AND ( ( NOT ( var3 IN ( '1980-06-12 23:03:39', '1971-09-08' ) ) AND EXISTS ( SELECT MAX( c0 ) FROM ( SELECT DISTINCT a1.c0, a1.c1, a1.c3, a1.c2, a1.c4, a1.c5, a1.c6, a1.c7, a1.c8, a1.c9 FROM rqg_table3 a1 WHERE a1.c1 != v1 AND ( ( a1.c1 = 6 AND ( ( ( c0type = a1.c0 AND v1 = 8 ) OR ( a1.c0 = 9 ) AND c0type IS NOT NULL ) OR ( a1.c7 IS NULL ) AND a1.c9 > -7.00378417669129e+124 ) AND ( var1 BETWEEN 6 AND 6 + 10 ) ) OR ( a1.c1 BETWEEN 6 AND 6 + 10 ) AND v4 IN ( '2026-04-11 19:57:04.055953','2033-01-12 21:20:59.050686' ) ) AND ( var4 NOT IN ( v4, a1.c6 ) ) GROUP BY a1.c0, a1.c1, a1.c3, a1.c2, a1.c4, a1.c5, a1.c6, a1.c7, a1.c8, a1.c9 HAVING ( v3 != '2016-03-07 18:20:30' ) AND ( var5 IN ( a1.c8, a1.c9 ) ) ) mm ) ) OR ( c0type = 3 ) AND 2 < 0 ) AND ( 0 <= 0 ) order by 1 limit 1;
 begin begin begin set enable_mergejoin to off;
 exception when others then begin begin delete from tmp2 t1 where NOT ( NOT EXISTS ( SELECT c7 FROM ( SELECT a1.c0, a1.c1, a1.c3, a1.c2, a1.c4, a1.c5, a1.c6, a1.c7, a1.c8, a1.c9 FROM ( SELECT a2.c0, a2.c1, a2.c3, a2.c2, a2.c4, a2.c5, a2.c6, a2.c7, a1.c8, a1.c9 FROM tmp2 a1 INNER JOIN tmp2 a2 ON ( ( NOT ( var3 NOT BETWEEN '1981-06-20 04:10:36' AND TO_DATE( '1981-06-20 04:10:36','YYYY-MM-DD HH24:MI:SS') + interval '1' day ) AND ( a1.c0 = a2.c0 +1 ) ) AND ( a1.c6 IS NOT NULL ) ) WHERE a2.c2 IN ( var2, a1.c3 ) AND ( 2 + 9 ) <= a1.c1 ) a1 WHERE ( NOT ( a1.c2 IS NULL ) AND v1 = 0 ) OR ( v3 NOT BETWEEN '1981-06-20 04:10:36' AND TO_DATE( '1981-06-20 04:10:36','YYYY-MM-DD HH24:MI:SS') + interval '1' day ) AND a1.c9 IS NOT NULL GROUP BY a1.c0, a1.c1, a1.c3, a1.c2, a1.c4, a1.c5, a1.c6, a1.c7, a1.c8, a1.c9 HAVING ( a1.c0 BETWEEN 6 AND 6 + 10 ) AND ( v3 NOT BETWEEN '1981-06-20 04:10:36' AND TO_DATE( '1981-06-20 04:10:36','YYYY-MM-DD HH24:MI:SS') + interval '1' day ) ) mm ) ) AND v2 not LIKE 'N9%';
 end;
 exception when others then begin select c1 into var1 from ( SELECT DISTINCT a2.c0, a1.c1, a2.c3, a2.c2, a1.c4, a1.c5, a2.c6, a1.c7, a2.c8, a2.c9 FROM ( rqg_table3 a1 LEFT JOIN ( SELECT a2.c0, a2.c1, a1.c3, a1.c2, a1.c4, a1.c5, a1.c6, a2.c7, a1.c8, a1.c9 FROM tmp1 a1 RIGHT JOIN tmp2 a2 ON ( ( NOT ( c0type = a2.c0 ) AND ( a1.c0 = a2.c0 +1 ) ) AND ( a1.c0 NOT IN ( 3, 9, 4 ) ) ) WHERE NOT ( a2.c0 = a1.c0 ) AND a2.c1 = var1 ) a2 ON ( NOT ( v1 = 3 ) AND ( a1.c0 = a2.c0 +1 ) ) ) RIGHT JOIN ( SELECT a1.c0, a1.c1, a1.c3, a1.c2, a1.c4, a2.c5, a2.c6, a1.c7, a1.c8, a2.c9 FROM ( rqg_table2 a1 RIGHT JOIN rqg_table4 a2 ON ( ( ( var1 = 3 AND ( a1.c0 = a2.c0 ) ) AND ( a1.c5 IN ( v3, var3 ) ) ) OR ( a2.c5 NOT BETWEEN '1981-06-20 04:10:36' AND TO_DATE( '1981-06-20 04:10:36','YYYY-MM-DD HH24:MI:SS') + interval '1' day ) AND ( a1.c0 = a2.c0 ) ) ) LEFT JOIN rqg_table2 a3 ON ( ( a3.c5 <= '1980-03-02' AND ( a1.c0 = a3.c0 ) ) OR ( a1.c8 < -6.47613525038239e+124 ) AND ( a1.c0 = a3.c0 ) ) WHERE NOT ( v3 NOT BETWEEN '1981-06-20 04:10:36' AND TO_DATE( '1981-06-20 04:10:36','YYYY-MM-DD HH24:MI:SS') + interval '1' day ) AND a1.c2 IS NULL GROUP BY a1.c0, a1.c1, a1.c3, a1.c2, a1.c4, a2.c5, a2.c6, a1.c7, a1.c8, a2.c9 HAVING ( NOT ( c0type IS NULL ) ) AND ( var1 >= 46108 ) ) a3 ON ( a3.c8 >= 0.00000000123456789123456789123456789123456789123456789 AND ( a1.c0 = a3.c0 ) ) WHERE a2.c0 < c0type AND a3.c0 = a1.c1 ) t1 where v3 >= ( SELECT MAX( c4 ) FROM ( SELECT a1.c0, a2.c1, a1.c3, a2.c2, a1.c4, a2.c5, a2.c6, a2.c7, a2.c8, a1.c9 FROM rqg_table2 a1 RIGHT JOIN rqg_table5 a2 ON ( ( 3 + 7 ) > a1.c0 AND ( a1.c0 = a2.c0 ) ) WHERE a1.c0 = 9 AND a1.c1 = 9 GROUP BY a1.c0, a2.c1, a1.c3, a2.c2, a1.c4, a2.c5, a2.c6, a2.c7, a2.c8, a1.c9 HAVING NOT ( a2.c1 < var1 ) ) mm ) order by 1 limit 1;
 end;
 end;
 end;
 end;
 exception when others then begin begin select c2 into c2type from ( SELECT a1.c0, a2.c1, a2.c3, a2.c2, a2.c4, a2.c5, a2.c6, a1.c7, a1.c8, a1.c9 FROM rqg_table4 a1 INNER JOIN rqg_table3 a2 ON ( v1 = v1 AND ( a1.c0 = a2.c0 ) ) WHERE a1.c1 = 2 GROUP BY a1.c0, a2.c1, a2.c3, a2.c2, a2.c4, a2.c5, a2.c6, a1.c7, a1.c8, a1.c9 HAVING ( ( a2.c5 NOT IN ( SELECT c5 FROM ( SELECT DISTINCT a2.c0, a2.c1, a2.c3, a2.c2, a2.c4, a2.c5, a1.c6, a1.c7, a1.c8, a1.c9 FROM ( ( SELECT DISTINCT a1.c0, a1.c1, a1.c3, a1.c2, a1.c4, a1.c5, a1.c6, a1.c7, a1.c8, a1.c9 FROM rqg_table3 a1 WHERE ( a1.c1 = 0 ) OR ( var1 = v1 ) AND 0 > 5 ) a1 LEFT JOIN rqg_table4 a2 ON ( NOT ( v1 = 5 ) AND ( a1.c0 = a2.c0 +1 ) ) ) LEFT JOIN rqg_table1 a3 ON ( a3.c1 BETWEEN 6 AND 6 + 10 AND ( a1.c0 = a3.c0 ) ) WHERE a3.c1 = 1 ) mm ) ) OR ( v4 IS NULL ) ) OR ( a2.c3 IS NULL ) ) t1 where NOT ( v4 NOT BETWEEN '2028-03-09 00:36:50.057488' AND TO_timestamp( '2028-03-09 00:36:50.057488','YYYY-MM-DD HH24:MI:SS.US') + interval '1' day ) AND c2type >= 'goq' order by 1 limit 1;
 end;
 end;
 end;
 exception when others then begin c0type =COALESCE ( (select c0 from ( SELECT a2.c0, a1.c1, a2.c3, a2.c2, a1.c4, a2.c5, a1.c6, a1.c7, a1.c8, a2.c9 FROM ( tmp2 a1 INNER JOIN rqg_table5 a2 ON ( ( ( ( ( a2.c1 = a1.c1 AND ( a1.c0 = a2.c0 ) ) AND ( a2.c1 = a2.c1 ) ) AND ( v1 NOT IN ( a1.c0, a2.c1 ) ) ) OR ( a2.c1 IN ( 3, 7, 5, 4, 6 ) ) AND ( a1.c0 = a2.c0 ) ) AND ( a2.c3 not LIKE 'N9%' ) ) ) RIGHT JOIN rqg_table6 a3 ON ( var2 IS NOT NULL AND ( a1.c0 = a3.c0 ) ) WHERE a3.c8 IS NOT NULL )mm order by 1 limit 1),0)+COALESCE(var1,0);
v2=var2;
var3=v3;
v4=var4+ interval '1' day;
v5=(v5+v5)%var5;
 end;
 end;
 end;
 end;
 END ;
$$ ;

rollback;

SET search_path TO chqin,public;

DROP TABLE if exists tmp1 cascade;
DROP TABLE if exists tmp2 cascade;
DROP TABLE if exists rqg_table6 cascade;
DROP TABLE if exists rqg_table5 cascade;
DROP TABLE if exists rqg_table4 cascade;
DROP TABLE if exists rqg_table3 cascade;
DROP TABLE if exists rqg_table2 cascade;
DROP TABLE if exists rqg_table1 cascade;

SET search_path TO postgres,public;
DROP SCHEMA if exists chqin CASCADE;

\c regression_ora;
create table t123_0909(a int, b int) distribute by shard(a);
insert into t123_0909 values (1,2);
insert into t123_0909 values (2,2);


begin ;

CREATE or replace PROCEDURE procsel(IN OUT V1 INT) AS $$ 
DECLARE TMP INT; 
BEGIN 
select 1/0 INTO TMP from t123_0909;
tmp := 1/0;
EXCEPTION WHEN OTHERS THEN 
V1:= -1; 
raise notice 'ex';
END; $$ LANGUAGE plpgsql;

call procsel(1) ;



CREATE or replace PROCEDURE procsel(IN OUT V1 INT) AS $$ 
DECLARE TMP INT; 
BEGIN 
select 1/0 INTO TMP from t123_0909;
tmp := 1/0;
EXCEPTION WHEN OTHERS THEN 
V1:= -1; 
raise notice 'ex';
END; $$ LANGUAGE plpgsql;

call procsel(1) ;

drop procedure procsel;
drop table t123_0909;

\c regression;
